/// <summary>
/// 转换数据实体
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
private static Model.ConfigDictionaryNew TranEntity(DataRow row)
{
Model.ConfigDictionaryNew model = new Model.ConfigDictionaryNew();
if (row != null)
{
if (row["Code"] != null)
{
model.Code = row["Code"].ToString();
}
if (row["Dkey"] != null)
{
model.Dkey = row["Dkey"].ToString();
}
if (row["TJCount"] != null && row["TJCount"].ToString() != "")
{
model.TJCount = int.Parse(row["TJCount"].ToString());
}
if (row["SubTJCount"] != null && row["SubTJCount"].ToString() != "")
{
model.SubTJCount = int.Parse(row["SubTJCount"].ToString());
}
if (row["GJCount"] != null && row["GJCount"].ToString() != "")
{
model.GJCount = int.Parse(row["GJCount"].ToString());
}
if (row["CJCount"] != null && row["CJCount"].ToString() != "")
{
model.CJCount = int.Parse(row["CJCount"].ToString());
}
if (row["FHMoney"] != null && row["FHMoney"].ToString() != "")
{
model.FHMoney = decimal.Parse(row["FHMoney"].ToString());
}
if (row["OutFloat"] != null && row["OutFloat"].ToString() != "")
{
model.OutFloat = decimal.Parse(row["OutFloat"].ToString());
}
if (row["HBFHFloat"] != null && row["HBFHFloat"].ToString() != "")
{
model.HBFHFloat = decimal.Parse(row["HBFHFloat"].ToString());
}
if (row["FHDays"] != null && row["FHDays"].ToString() != "")
{
model.FHDays = int.Parse(row["FHDays"].ToString());
}
}
return(model);
}
public static Hashtable Insert(Model.ConfigDictionaryNew model, Hashtable MyHs)
{
StringBuilder strSql = new StringBuilder();
string guid = Guid.NewGuid().ToString();
strSql.Append("insert into ConfigDictionaryNew(");
strSql.Append("Code,Dkey,TJCount,SubTJCount,GJCount,CJCount,FHMoney,OutFloat,HBFHFloat,FHDays)");
strSql.Append(" values (");
strSql.Append("@Code,@Dkey,@TJCount,@SubTJCount,@GJCount,@CJCount,@FHMoney,@OutFloat,@HBFHFloat,@FHDays)");
SqlParameter[] parameters =
{
new SqlParameter("@Code", SqlDbType.VarChar, 10),
new SqlParameter("@Dkey", SqlDbType.VarChar, 10),
new SqlParameter("@TJCount", SqlDbType.Int, 4),
new SqlParameter("@SubTJCount", SqlDbType.Int, 4),
new SqlParameter("@GJCount", SqlDbType.Int, 4),
new SqlParameter("@CJCount", SqlDbType.Int, 4),
new SqlParameter("@FHMoney", SqlDbType.Decimal, 9),
new SqlParameter("@OutFloat", SqlDbType.Decimal, 9),
new SqlParameter("@HBFHFloat", SqlDbType.Decimal, 9),
new SqlParameter("@FHDays", SqlDbType.Int, 4)
};
parameters[0].Value = model.Code;
parameters[1].Value = model.Dkey;
parameters[2].Value = model.TJCount;
parameters[3].Value = model.SubTJCount;
parameters[4].Value = model.GJCount;
parameters[5].Value = model.CJCount;
parameters[6].Value = model.FHMoney;
parameters[7].Value = model.OutFloat;
parameters[8].Value = model.HBFHFloat;
parameters[9].Value = model.FHDays;
strSql.AppendFormat("; select '{0}';", guid);
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
