public static Hashtable Insert(Model.NConfigDictionary model, Hashtable MyHs)
{
StringBuilder strSql = new StringBuilder();
string guid = Guid.NewGuid().ToString();
strSql.Append("insert into NConfigDictionary(");
strSql.Append("NDTpye,DKey,StartLevel,EndLevel,StartRec,EndRec,DValue,Remark)");
strSql.Append(" values (");
strSql.Append("@NDTpye,@DKey,@StartLevel,@EndLevel,@StartRec,@EndRec,@DValue,@Remark)");
SqlParameter[] parameters =
{
new SqlParameter("@NDTpye", SqlDbType.VarChar, 50),
new SqlParameter("@DKey", SqlDbType.VarChar, 10),
new SqlParameter("@StartLevel", SqlDbType.Int, 4),
new SqlParameter("@EndLevel", SqlDbType.Int, 4),
new SqlParameter("@StartRec", SqlDbType.Int, 4),
new SqlParameter("@EndRec", SqlDbType.Int, 4),
new SqlParameter("@DValue", SqlDbType.VarChar, 10),
new SqlParameter("@Remark", SqlDbType.VarChar, 100)
};
parameters[0].Value = model.NDTpye;
parameters[1].Value = model.DKey;
parameters[2].Value = model.StartLevel;
parameters[3].Value = model.EndLevel;
parameters[4].Value = model.StartRec;
parameters[5].Value = model.EndRec;
parameters[6].Value = model.DValue;
parameters[7].Value = model.Remark;
strSql.AppendFormat("; select '{0}';", guid);
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
/// <summary>
/// 转换数据实体
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
private static Model.NConfigDictionary TranEntity(DataRow row)
{
Model.NConfigDictionary model = new Model.NConfigDictionary();
if (row != null)
{
if (row["NDTpye"] != null)
{
model.NDTpye = row["NDTpye"].ToString();
}
if (row["DKey"] != null)
{
model.DKey = row["DKey"].ToString();
}
if (row["StartLevel"] != null && row["StartLevel"].ToString() != "")
{
model.StartLevel = int.Parse(row["StartLevel"].ToString());
}
if (row["EndLevel"] != null && row["EndLevel"].ToString() != "")
{
model.EndLevel = int.Parse(row["EndLevel"].ToString());
}
if (row["StartRec"] != null && row["StartRec"].ToString() != "")
{
model.StartRec = int.Parse(row["StartRec"].ToString());
}
if (row["EndRec"] != null && row["EndRec"].ToString() != "")
{
model.EndRec = int.Parse(row["EndRec"].ToString());
}
if (row["DValue"] != null)
{
model.DValue = row["DValue"].ToString();
}
if (row["Remark"] != null)
{
model.Remark = row["Remark"].ToString();
}
}
return(model);
}
