本文整理汇总了C#中Conditions.column方法的典型用法代码示例。如果您正苦于以下问题：C# Conditions.column方法的具体用法？C# Conditions.column怎么用？C# Conditions.column使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Conditions的用法示例。
在下文中一共展示了Conditions.column方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: AddCheck
public ActionResult AddCheck(string appName, string tableName, FormCollection fc)
{
DBApp app = new DBApp()
{
Name = appName,
ConnectionString = (new Entities()).Database.Connection.ConnectionString
};
DBTable table = app.GetTable(tableName);
foreach (string checkConstraint in table.GetCheckConstraints()) //constraint name control in table
{
if (checkConstraint == "CHK_" + appName + "_" + tableName + "_" + fc["checkName"])
{
TempData["message-error"] = "Check constraint with name " + checkConstraint + " is already exist.";
return RedirectToAction("Index", new { @appName = appName });
}
}
int i = 0;
Conditions con = new Conditions(new SqlQuery());
Condition_Operators ope = new Condition_Operators(con);
Condition_concat concat = new Condition_concat(con);
while (fc["column[" + i + "]"] != null)
{
DBColumn col = table.columns.SingleOrDefault(x => x.Name == fc["column[" + i + "]"]);
object val = table.ConvertValue(col, fc["value[" + i + "]"]);
con.column(col.Name);
con.isCheck = true;
if (i != 0) concat.and();
ope = table.GetConditionOperators(con, fc["conOperator[" + i + "]"], val);
i++;
}
table.AddCheck(fc["checkName"], con);
app.SaveChanges();
TempData["message-success"] = "Check constraint " + fc["checkName"] + " was successfully added into table " + tableName + ".";
return RedirectToAction("Index", new { @appName = appName });
}示例2: InsertSelect
public ActionResult InsertSelect(string appName, string tableName, List<string> columnsA, List<string> columnsB, string tableB, FormCollection fc)
{
DBApp app = new DBApp()
{
Name = appName,
ConnectionString = (new Entities()).Database.Connection.ConnectionString
};
DBTable table = app.GetTable(tableName);
Conditions con = new Conditions(new SqlQuery());
if (fc["conOperator[0]"] != "")
{
Condition_Operators ope = new Condition_Operators(con);
Condition_concat concat = new Condition_concat(con);
int i = 0;
while (fc["column[" + i + "]"] != null)
{
DBColumn col = table.columns.SingleOrDefault(x => x.Name == fc["column[" + i + "]"]);
object val = table.ConvertValue(col, fc["value[" + i + "]"]);
con.column(col.Name);
if (i != 0) concat.and();
ope = table.GetConditionOperators(con, fc["conOperator[" + i + "]"], val);
i++;
}
}
table.InsertSelect(columnsA, tableB, columnsB, con.ToString());
app.SaveChanges();
TempData["message-success"] = "Row(s) was successfully inserted.";
return RedirectToAction("Data", new { @appName = appName, @tableName = tableName });
}