/// <summary>
/// 增加一条数据
/// </summary>
public void Add(MobileSoft.Model.HSPR.Tb_HSPR_CostStandard model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@StanID", SqlDbType.BigInt, 8),
new SqlParameter("@CommID", SqlDbType.Int, 4),
new SqlParameter("@CostID", SqlDbType.BigInt, 8),
new SqlParameter("@StanSign", SqlDbType.NVarChar, 20),
new SqlParameter("@StanName", SqlDbType.NVarChar, 30),
new SqlParameter("@StanExplain", SqlDbType.NVarChar, 50),
new SqlParameter("@StanFormula", SqlDbType.NVarChar, 20),
new SqlParameter("@StanAmount", SqlDbType.Decimal, 9),
new SqlParameter("@StanStartDate", SqlDbType.DateTime),
new SqlParameter("@StanEndDate", SqlDbType.DateTime),
new SqlParameter("@IsCondition", SqlDbType.SmallInt, 2),
new SqlParameter("@ConditionField", SqlDbType.NVarChar, 20),
new SqlParameter("@DelinRates", SqlDbType.Decimal, 9),
new SqlParameter("@DelinDelay", SqlDbType.Int, 4),
new SqlParameter("@IsDelete", SqlDbType.SmallInt, 2),
new SqlParameter("@IsStanRange", SqlDbType.SmallInt, 2),
new SqlParameter("@ChargeCycle", SqlDbType.Int, 4),
new SqlParameter("@ManageFeesStyle", SqlDbType.SmallInt, 2),
new SqlParameter("@ManageFeesAmount", SqlDbType.Decimal, 9),
new SqlParameter("@CorpStanID", SqlDbType.BigInt, 8),
new SqlParameter("@CorpCostID", SqlDbType.BigInt, 8),
new SqlParameter("@AmountRounded", SqlDbType.Decimal, 9),
new SqlParameter("@Modulus", SqlDbType.Decimal, 9),
new SqlParameter("@DelinType", SqlDbType.SmallInt, 2),
new SqlParameter("@DelinDay", SqlDbType.Int, 4)
};
parameters[0].Value = model.StanID;
parameters[1].Value = model.CommID;
parameters[2].Value = model.CostID;
parameters[3].Value = model.StanSign;
parameters[4].Value = model.StanName;
parameters[5].Value = model.StanExplain;
parameters[6].Value = model.StanFormula;
parameters[7].Value = model.StanAmount;
parameters[8].Value = model.StanStartDate;
parameters[9].Value = model.StanEndDate;
parameters[10].Value = model.IsCondition;
parameters[11].Value = model.ConditionField;
parameters[12].Value = model.DelinRates;
parameters[13].Value = model.DelinDelay;
parameters[14].Value = model.IsDelete;
parameters[15].Value = model.IsStanRange;
parameters[16].Value = model.ChargeCycle;
parameters[17].Value = model.ManageFeesStyle;
parameters[18].Value = model.ManageFeesAmount;
parameters[19].Value = model.CorpStanID;
parameters[20].Value = model.CorpCostID;
parameters[21].Value = model.AmountRounded;
parameters[22].Value = model.Modulus;
parameters[23].Value = model.DelinType;
parameters[24].Value = model.DelinDay;
DbHelperSQL.RunProcedure("Proc_Tb_HSPR_CostStandard_ADD", parameters, out rowsAffected);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MobileSoft.Model.HSPR.Tb_HSPR_CostStandard GetModel(long StanID)
{
SqlParameter[] parameters =
{
new SqlParameter("@StanID", SqlDbType.BigInt)
};
parameters[0].Value = StanID;
MobileSoft.Model.HSPR.Tb_HSPR_CostStandard model = new MobileSoft.Model.HSPR.Tb_HSPR_CostStandard();
DataSet ds = DbHelperSQL.RunProcedure("Proc_Tb_HSPR_CostStandard_GetModel", parameters, "ds");
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["StanID"].ToString() != "")
{
model.StanID = long.Parse(ds.Tables[0].Rows[0]["StanID"].ToString());
}
if (ds.Tables[0].Rows[0]["CommID"].ToString() != "")
{
model.CommID = int.Parse(ds.Tables[0].Rows[0]["CommID"].ToString());
}
if (ds.Tables[0].Rows[0]["CostID"].ToString() != "")
{
model.CostID = long.Parse(ds.Tables[0].Rows[0]["CostID"].ToString());
}
model.StanSign = ds.Tables[0].Rows[0]["StanSign"].ToString();
model.StanName = ds.Tables[0].Rows[0]["StanName"].ToString();
model.StanExplain = ds.Tables[0].Rows[0]["StanExplain"].ToString();
model.StanFormula = ds.Tables[0].Rows[0]["StanFormula"].ToString();
if (ds.Tables[0].Rows[0]["StanAmount"].ToString() != "")
{
model.StanAmount = decimal.Parse(ds.Tables[0].Rows[0]["StanAmount"].ToString());
}
if (ds.Tables[0].Rows[0]["StanStartDate"].ToString() != "")
{
model.StanStartDate = DateTime.Parse(ds.Tables[0].Rows[0]["StanStartDate"].ToString());
}
if (ds.Tables[0].Rows[0]["StanEndDate"].ToString() != "")
{
model.StanEndDate = DateTime.Parse(ds.Tables[0].Rows[0]["StanEndDate"].ToString());
}
if (ds.Tables[0].Rows[0]["IsCondition"].ToString() != "")
{
model.IsCondition = int.Parse(ds.Tables[0].Rows[0]["IsCondition"].ToString());
}
model.ConditionField = ds.Tables[0].Rows[0]["ConditionField"].ToString();
if (ds.Tables[0].Rows[0]["DelinRates"].ToString() != "")
{
model.DelinRates = decimal.Parse(ds.Tables[0].Rows[0]["DelinRates"].ToString());
}
if (ds.Tables[0].Rows[0]["DelinDelay"].ToString() != "")
{
model.DelinDelay = int.Parse(ds.Tables[0].Rows[0]["DelinDelay"].ToString());
}
if (ds.Tables[0].Rows[0]["IsDelete"].ToString() != "")
{
model.IsDelete = int.Parse(ds.Tables[0].Rows[0]["IsDelete"].ToString());
}
if (ds.Tables[0].Rows[0]["IsStanRange"].ToString() != "")
{
model.IsStanRange = int.Parse(ds.Tables[0].Rows[0]["IsStanRange"].ToString());
}
if (ds.Tables[0].Rows[0]["ChargeCycle"].ToString() != "")
{
model.ChargeCycle = int.Parse(ds.Tables[0].Rows[0]["ChargeCycle"].ToString());
}
if (ds.Tables[0].Rows[0]["ManageFeesStyle"].ToString() != "")
{
model.ManageFeesStyle = int.Parse(ds.Tables[0].Rows[0]["ManageFeesStyle"].ToString());
}
if (ds.Tables[0].Rows[0]["ManageFeesAmount"].ToString() != "")
{
model.ManageFeesAmount = decimal.Parse(ds.Tables[0].Rows[0]["ManageFeesAmount"].ToString());
}
if (ds.Tables[0].Rows[0]["CorpStanID"].ToString() != "")
{
model.CorpStanID = long.Parse(ds.Tables[0].Rows[0]["CorpStanID"].ToString());
}
if (ds.Tables[0].Rows[0]["CorpCostID"].ToString() != "")
{
model.CorpCostID = long.Parse(ds.Tables[0].Rows[0]["CorpCostID"].ToString());
}
if (ds.Tables[0].Rows[0]["AmountRounded"].ToString() != "")
{
model.AmountRounded = decimal.Parse(ds.Tables[0].Rows[0]["AmountRounded"].ToString());
}
if (ds.Tables[0].Rows[0]["Modulus"].ToString() != "")
{
model.Modulus = decimal.Parse(ds.Tables[0].Rows[0]["Modulus"].ToString());
}
if (ds.Tables[0].Rows[0]["DelinType"].ToString() != "")
{
model.DelinType = int.Parse(ds.Tables[0].Rows[0]["DelinType"].ToString());
}
if (ds.Tables[0].Rows[0]["DelinDay"].ToString() != "")
{
model.DelinDay = int.Parse(ds.Tables[0].Rows[0]["DelinDay"].ToString());
}
return(model);
}
else
{
return(null);
}
}