protected virtual Dictionary <string, object> GetParm(CrParameter argsInfo)
{
var data = new Dictionary <string, object>();
var args = argsInfo.SendContent;
if (!string.IsNullOrEmpty(args))
{
data["cargs"] = args;
}
data["ruleId"] = SelectedRuleId;
data["num"] = argsInfo.UseNum.ToString(CultureInfo.InvariantCulture);
return(data);
}
/// <summary>
/// 获取选择的参数
/// </summary>
/// <param name="cArgs"></param>
/// <returns></returns>
protected CrParameter AnalyzeArgs(IDictionary <string, ItemData> cArgs)
{
var args = "";
var sign = "";
if (cArgs.ContainsKey(AllField))
{
cArgs.Remove(AllField);
}
var crparam = new CrParameter(args);
foreach (var pair in cArgs)
{
var createData = pair.Value;
var view = createData.View;
if (view != null)
{
var state = view.IsValid();
if (!state)
{
continue;
}
}
else
{
if (createData.Type != RuleItemType.none)
{
continue;
}
}
var key = createData.Key;
if (key == AllField)
{
continue;
}
crparam.AddKeyIfSpecial(key, createData.Value);
args = string.Format("{0}{1}{2},{3}", args, sign, createData.Id, createData.Value);
sign = ",";
var expnum = createData.UseNum;
if (expnum <= 0)
{
continue;
}
crparam.UseNum = expnum;
crparam.UseTyp = createData.UseItem;
}
YxDebug.Log(args);
crparam.SendContent = args;
return(crparam);
}
public static void Insert(Entity e)
{
string insertSql = "insert into [{0}]({1}) values({2})";
StringBuilder sbColumns = new StringBuilder();
StringBuilder sbParameters = new StringBuilder();
EntitySchema schema = EntitySchemaList.Instance.GetSchema(e.Name);
using (DbManager db = new DbManager())
{
foreach (EntityColumnSchema columnSchema in schema.Columns)
{
if (columnSchema.IsAutoInc)
{
continue;
}
sbColumns.Append(columnSchema.Name);
if (columnSchema.IsML)
{
//string lanCode =GetLanguagePostFix();
sbColumns.Append("_EN");
}
sbColumns.Append(",");
sbParameters.Append("~");
sbParameters.Append(columnSchema.Name);
sbParameters.Append(",");
CrParameter p = new CrParameter();
p.Name = columnSchema.Name;
p.Size = columnSchema.Size;
p.Type = columnSchema.Type;
p.Value = e.Get <object>(columnSchema.Name);
db.Parameters.Add(p);
}
insertSql = string.Format(insertSql, schema.Name, sbColumns.ToString().TrimEnd(','),
sbParameters.ToString().TrimEnd(','));
db.ExecuteNonQuery(insertSql);
}
}
