public static Hashtable Insert(Model.NewSHMoney model, Hashtable MyHs)
{
string guid = Guid.NewGuid().ToString();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into NewSHMoney(");
strSql.Append("NType,NName,NJCFloat,NTotalYJ,NSmallSumYJ,NDCount,NMinYJ)");
strSql.Append(" values (");
strSql.Append("@NType,@NName,@NJCFloat,@NTotalYJ,@NSmallSumYJ,@NDCount,@NMinYJ)");
SqlParameter[] parameters =
{
new SqlParameter("@NType", SqlDbType.VarChar, 10),
new SqlParameter("@NName", SqlDbType.VarChar, 20),
new SqlParameter("@NJCFloat", SqlDbType.Decimal, 9),
new SqlParameter("@NTotalYJ", SqlDbType.Decimal, 9),
new SqlParameter("@NSmallSumYJ", SqlDbType.Decimal, 9),
new SqlParameter("@NDCount", SqlDbType.Int, 4),
new SqlParameter("@NMinYJ", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.NType;
parameters[1].Value = model.NName;
parameters[2].Value = model.NJCFloat;
parameters[3].Value = model.NTotalYJ;
parameters[4].Value = model.NSmallSumYJ;
parameters[5].Value = model.NDCount;
parameters[6].Value = model.NMinYJ;
strSql.AppendFormat(";select '{0}'", guid);
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
/*
* /// <summary>
* /// 分页获取数据列表
* /// </summary>
* public DataSet GetList(int PageSize,int PageIndex,string strWhere)
* {
* SqlParameter[] parameters = {
* new SqlParameter("@tblName", SqlDbType.VarChar, 255),
* new SqlParameter("@fldName", SqlDbType.VarChar, 255),
* new SqlParameter("@PageSize", SqlDbType.Int),
* new SqlParameter("@PageIndex", SqlDbType.Int),
* new SqlParameter("@IsReCount", SqlDbType.Bit),
* new SqlParameter("@OrderType", SqlDbType.Bit),
* new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
* };
* parameters[0].Value = "NewSHMoney";
* parameters[1].Value = "NType";
* parameters[2].Value = PageSize;
* parameters[3].Value = PageIndex;
* parameters[4].Value = 0;
* parameters[5].Value = 0;
* parameters[6].Value = strWhere;
* return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
* }*/
#endregion BasicMethod
#region ExtensionMethod
/// <summary>
/// 得到绑定列表
/// </summary>
/// <returns></returns>
public static Dictionary <string, Model.NewSHMoney> GetNewSHMoneyList(DataTable table)
{
Dictionary <string, Model.NewSHMoney> SHMoneyList = new Dictionary <string, Model.NewSHMoney>();
if (table == null)
{
table = GetNewSHMoneyListDataTable();
}
foreach (DataRow dr in table.Rows)
{
Model.NewSHMoney model = DataRowToModel(dr);
SHMoneyList.Add(model.NType, model);
}
return(SHMoneyList);
}
