/// <summary>
/// 得到一个对象实体
/// </summary>
public viviapi.Model.Finance.PayRate GetModel(byte rateType, int billId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,rateType,billId,billame,p100,p101,p102,p103,p104,p105,p106,p107,p108,p109,p110,p111,p112,p113,p114,p115,p116,p117,p118,p119,p300,p200,p201,p202,p203,p204,p205,p207,p208,p209,p210,p206 from PayRate ");
strSql.Append(" where rateType=@rateType and billId=@billId");
SqlParameter[] parameters =
{
new SqlParameter("@rateType", SqlDbType.TinyInt, 1)
, new SqlParameter("@billId", SqlDbType.Int, 4)
};
parameters[0].Value = rateType;
parameters[1].Value = billId;
viviapi.Model.Finance.PayRate model = new viviapi.Model.Finance.PayRate();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public int Insert(viviapi.Model.Finance.PayRate model)
{
try
{
return(dal.Insert(model));
}
catch (Exception ex)
{
ExceptionHandler.HandleException(ex);
return(0);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public viviapi.Model.Finance.PayRate GetModelByUser(int userId)
{
SqlParameter[] parameters =
{
new SqlParameter("@userid", SqlDbType.Int, 4)
};
parameters[0].Value = userId;
viviapi.Model.Finance.PayRate model = new viviapi.Model.Finance.PayRate();
DataSet ds = DataBase.ExecuteDataset(CommandType.StoredProcedure, "proc_payrate_getmodelbyuser", parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected void btnCopy_Click(object sender, EventArgs e)
{
viviapi.Model.Finance.PayRate _model = viviapi.BLL.Finance.PayRate.Instance.GetModelByUser(this.ItemInfoId);
if (_model != null)
{
this.txtp100.Text = (Convert.ToDecimal(_model.p100) * 100).ToString("0.00");
this.txtp101.Text = (Convert.ToDecimal(_model.p101) * 100).ToString("0.00");
this.txtp102.Text = (Convert.ToDecimal(_model.p102) * 100).ToString("0.00");
this.txtp103.Text = (Convert.ToDecimal(_model.p103) * 100).ToString("0.00");
this.txtp104.Text = (Convert.ToDecimal(_model.p104) * 100).ToString("0.00");
this.txtp105.Text = (Convert.ToDecimal(_model.p105) * 100).ToString("0.00");
this.txtp106.Text = (Convert.ToDecimal(_model.p106) * 100).ToString("0.00");
this.txtp107.Text = (Convert.ToDecimal(_model.p107) * 100).ToString("0.00");
this.txtp108.Text = (Convert.ToDecimal(_model.p108) * 100).ToString("0.00");
this.txtp109.Text = (Convert.ToDecimal(_model.p109) * 100).ToString("0.00");
this.txtp110.Text = (Convert.ToDecimal(_model.p110) * 100).ToString("0.00");
this.txtp111.Text = (Convert.ToDecimal(_model.p111) * 100).ToString("0.00");
this.txtp112.Text = (Convert.ToDecimal(_model.p112) * 100).ToString("0.00");
this.txtp113.Text = (Convert.ToDecimal(_model.p113) * 100).ToString("0.00");
this.txtp114.Text = (Convert.ToDecimal(_model.p114) * 100).ToString("0.00");
this.txtp115.Text = (Convert.ToDecimal(_model.p115) * 100).ToString("0.00");
this.txtp116.Text = (Convert.ToDecimal(_model.p116) * 100).ToString("0.00");
this.txtp117.Text = (Convert.ToDecimal(_model.p117) * 100).ToString("0.00");
this.txtp118.Text = (Convert.ToDecimal(_model.p118) * 100).ToString("0.00");
this.txtp119.Text = (Convert.ToDecimal(_model.p119) * 100).ToString("0.00");
this.txtp200.Text = (Convert.ToDecimal(_model.p200) * 100).ToString("0.00");
this.txtp201.Text = (Convert.ToDecimal(_model.p201) * 100).ToString("0.00");
this.txtp202.Text = (Convert.ToDecimal(_model.p202) * 100).ToString("0.00");
this.txtp203.Text = (Convert.ToDecimal(_model.p203) * 100).ToString("0.00");
this.txtp204.Text = (Convert.ToDecimal(_model.p204) * 100).ToString("0.00");
this.txtp205.Text = (Convert.ToDecimal(_model.p205) * 100).ToString("0.00");
this.txtp208.Text = (Convert.ToDecimal(_model.p208) * 100).ToString("0.00");
this.txtp209.Text = (Convert.ToDecimal(_model.p209) * 100).ToString("0.00");
this.txtp300.Text = (Convert.ToDecimal(_model.p300) * 100).ToString("0.00");
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(viviapi.Model.Finance.PayRate model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(viviapi.Model.Finance.PayRate model)
{
return(dal.Add(model));
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
var userInfo = viviapi.BLL.User.Factory.GetModel(this.UserId);
if (userInfo == null)
{
ShowMessageBox("商户不存在");
return;
}
var amtInfo = AmtInfo;
if (amtInfo == null)
{
amtInfo = new UserSettingInfo {
userid = UserId, special = (byte)(this.ckb_isopen.Checked ? 1 : 0)
};
}
else
{
amtInfo.userid = UserId;
amtInfo.special = (byte)(this.ckb_isopen.Checked ? 1 : 0);
}
amtInfo.payrate = 0;
if (amtInfo.special == 1)
{
#region check value
string strErr = string.Empty;
if (!viviLib.Text.Validate.IsNumber(txtp100.Text))
{
strErr += "p100格式错误！\n";
}
if (!viviLib.Text.Validate.IsNumber(txtp101.Text))
{
strErr += "p101格式错误！\n";
}
if (!viviLib.Text.Validate.IsNumber(txtp102.Text))
{
strErr += "p102格式错误！\n";
}
if (!viviLib.Text.Validate.IsNumber(txtp103.Text))
{
strErr += "p103格式错误！\n";
}
if (!viviLib.Text.Validate.IsNumber(txtp104.Text))
{
strErr += "p104格式错误！\n";
}
if (!viviLib.Text.Validate.IsNumber(txtp105.Text))
{
strErr += "p105格式错误！\n";
}
if (!viviLib.Text.Validate.IsNumber(txtp106.Text))
{
strErr += "p106格式错误！\n";
}
if (!viviLib.Text.Validate.IsNumber(txtp107.Text))
{
strErr += "p107格式错误！\n";
}
if (!viviLib.Text.Validate.IsNumber(txtp108.Text))
{
strErr += "p108格式错误！\n";
}
if (!viviLib.Text.Validate.IsNumber(txtp109.Text))
{
strErr += "p109格式错误！\n";
}
if (!viviLib.Text.Validate.IsNumber(txtp110.Text))
{
strErr += "p110格式错误！\n";
}
if (!viviLib.Text.Validate.IsNumber(txtp111.Text))
{
strErr += "p111格式错误！\n";
}
if (!viviLib.Text.Validate.IsNumber(txtp112.Text))
{
strErr += "p112格式错误！\n";
}
if (!viviLib.Text.Validate.IsNumber(txtp113.Text))
{
strErr += "p113格式错误！\n";
}
//if (!viviLib.Text.Validate.IsNumber(txtp114.Text))
//{
// strErr += "p114格式错误！\n";
//}
//if (!viviLib.Text.Validate.IsNumber(txtp115.Text))
//{
// strErr += "p115格式错误！\n";
//}
//if (!viviLib.Text.Validate.IsNumber(txtp116.Text))
//{
// strErr += "p116格式错误！\n";
//}
if (!viviLib.Text.Validate.IsNumber(txtp117.Text))
{
strErr += "p117格式错误！\n";
}
if (!viviLib.Text.Validate.IsNumber(txtp118.Text))
{
strErr += "p118格式错误！\n";
}
if (!viviLib.Text.Validate.IsNumber(txtp119.Text))
{
strErr += "p119格式错误！\n";
}
//if (!viviLib.Text.Validate.IsNumber(txtp200.Text))
//{
// strErr += "p200格式错误！\n";
//}
//if (!viviLib.Text.Validate.IsNumber(txtp201.Text))
//{
// strErr += "p201格式错误！\n";
//}
//if (!viviLib.Text.Validate.IsNumber(txtp202.Text))
//{
// strErr += "p202格式错误！\n";
//}
if (!viviLib.Text.Validate.IsNumber(txtp203.Text))
{
strErr += "p203格式错误！\n";
}
if (!viviLib.Text.Validate.IsNumber(txtp204.Text))
{
strErr += "p204格式错误！\n";
}
if (!viviLib.Text.Validate.IsNumber(txtp205.Text))
{
strErr += "p205格式错误！\n";
}
if (!viviLib.Text.Validate.IsNumber(txtp207.Text))
{
strErr += "p207格式错误！\n";
}
if (!viviLib.Text.Validate.IsNumber(txtp208.Text))
{
strErr += "p208格式错误！\n";
}
if (!viviLib.Text.Validate.IsNumber(txtp209.Text))
{
strErr += "p209格式错误！\n";
}
if (!viviLib.Text.Validate.IsNumber(txtp300.Text))
{
strErr += "p300格式错误！\n";
}
#endregion
if (strErr != "")
{
ShowMessageBox(strErr);
return;
}
#region
decimal p100 = decimal.Parse(this.txtp100.Text) / 100;
decimal p101 = decimal.Parse(this.txtp101.Text) / 100;
decimal p102 = decimal.Parse(this.txtp102.Text) / 100;
decimal p103 = decimal.Parse(this.txtp103.Text) / 100;
decimal p104 = decimal.Parse(this.txtp104.Text) / 100;
decimal p105 = decimal.Parse(this.txtp105.Text) / 100;
decimal p106 = decimal.Parse(this.txtp106.Text) / 100;
decimal p107 = decimal.Parse(this.txtp107.Text) / 100;
decimal p108 = decimal.Parse(this.txtp108.Text) / 100;
decimal p109 = decimal.Parse(this.txtp109.Text) / 100;
decimal p110 = decimal.Parse(this.txtp110.Text) / 100;
decimal p111 = decimal.Parse(this.txtp111.Text) / 100;
decimal p112 = decimal.Parse(this.txtp112.Text) / 100;
decimal p113 = decimal.Parse(this.txtp113.Text) / 100;
//decimal p114 = decimal.Parse(this.txtp114.Text) / 100;
//decimal p115 = decimal.Parse(this.txtp115.Text) / 100;
//decimal p116 = decimal.Parse(this.txtp116.Text) / 100;
decimal p117 = decimal.Parse(this.txtp117.Text) / 100;
decimal p118 = decimal.Parse(this.txtp118.Text) / 100;
decimal p119 = decimal.Parse(this.txtp119.Text) / 100;
decimal p200 = decimal.Parse(this.txtp200.Text) / 100;
//decimal p201 = decimal.Parse(this.txtp201.Text) / 100;
//decimal p202 = decimal.Parse(this.txtp202.Text) / 100;
decimal p203 = decimal.Parse(this.txtp203.Text) / 100;
decimal p204 = decimal.Parse(this.txtp204.Text) / 100;
decimal p205 = decimal.Parse(this.txtp205.Text) / 100;
// decimal p206 = decimal.Parse(this.txtp206.Text) / 100;
decimal p207 = decimal.Parse(this.txtp207.Text) / 100;
decimal p208 = decimal.Parse(this.txtp208.Text) / 100;
decimal p209 = decimal.Parse(this.txtp209.Text) / 100;
decimal p210 = decimal.Parse(this.txtp210.Text) / 100;
decimal p300 = decimal.Parse(this.txtp300.Text) / 100;
//decimal p100 = decimal.Parse(this.txtp100.Text) / 100;
//decimal p101 = decimal.Parse(this.txtp101.Text) / 100;
//decimal p102 = decimal.Parse(this.txtp102.Text) / 100;
//decimal p103 = decimal.Parse(this.txtp103.Text) / 100;
//decimal p104 = decimal.Parse(this.txtp104.Text) / 100;
//decimal p105 = decimal.Parse(this.txtp105.Text) / 100;
//decimal p106 = decimal.Parse(this.txtp106.Text) / 100;
//decimal p107 = decimal.Parse(this.txtp107.Text) / 100;
//decimal p108 = decimal.Parse(this.txtp108.Text) / 100;
//decimal p109 = decimal.Parse(this.txtp109.Text) / 100;
//decimal p110 = decimal.Parse(this.txtp110.Text) / 100;
//decimal p111 = decimal.Parse(this.txtp111.Text) / 100;
//decimal p112 = decimal.Parse(this.txtp112.Text) / 100;
//decimal p113 = decimal.Parse(this.txtp113.Text) / 100;
////decimal p114 = decimal.Parse(this.txtp114.Text) / 100;
////decimal p115 = decimal.Parse(this.txtp115.Text) / 100;
////decimal p116 = decimal.Parse(this.txtp116.Text) / 100;
//decimal p117 = decimal.Parse(this.txtp117.Text) / 100;
//decimal p118 = decimal.Parse(this.txtp118.Text) / 100;
//decimal p119 = decimal.Parse(this.txtp119.Text) / 100;
////decimal p200 = decimal.Parse(this.txtp200.Text) / 100;
////decimal p201 = decimal.Parse(this.txtp201.Text) / 100;
////decimal p202 = decimal.Parse(this.txtp202.Text) / 100;
//decimal p203 = decimal.Parse(this.txtp203.Text) / 100;
//decimal p204 = decimal.Parse(this.txtp204.Text) / 100;
//decimal p205 = decimal.Parse(this.txtp205.Text) / 100;
//decimal p206 = decimal.Parse(this.txtp206.Text) / 100;
//decimal p207 = decimal.Parse(this.txtp207.Text) / 100;
//decimal p208 = decimal.Parse(this.txtp208.Text) / 100;
//decimal p209 = decimal.Parse(this.txtp209.Text) / 100;
//decimal p210 = decimal.Parse(this.txtp210.Text) / 100;
//decimal p300 = decimal.Parse(this.txtp300.Text) / 100;
#endregion
#region
var rateInfo = new viviapi.Model.Finance.PayRate
{
rateType = 2,
billId = UserId,
billame = userInfo.UserName,
p100 = p100,
p101 = p101,
p102 = p102,
p103 = p103,
p104 = p104,
p105 = p105,
p106 = p106,
p107 = p107,
p108 = p108,
p109 = p109,
p110 = p110,
p111 = p111,
p112 = p112,
p113 = p113,
//p114 = p114,
//p115 = p115,
//p116 = p116,
p117 = p117,
p118 = p118,
p119 = p119,
p200 = p200,
//p201 = p201,
//p202 = p202,
p203 = p203,
p204 = p204,
p205 = p205,
// p206 = p206,
p207 = p207,
p208 = p208,
p209 = p209,
p210 = p210,
p300 = p300
};
if (MuserPayRate != null)
{
rateInfo.id = MuserPayRate.id;
}
int id = viviapi.BLL.Finance.PayRate.Instance.Insert(rateInfo);
if (id <= 0)
{
ShowMessageBox("保存失败");
return;
}
#endregion
amtInfo.payrate = id;
}
bool result = viviapi.BLL.User.UserSetting.Instance.PayRateConfig(amtInfo);
if (result)
{
ShowMessageBox("操作成功");
}
else
{
ShowMessageBox("操作失败");
}
}
public int Insert(viviapi.Model.Finance.PayRate model)
{
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@rateType", SqlDbType.TinyInt, 1),
new SqlParameter("@billId", SqlDbType.Int, 4),
new SqlParameter("@billame", SqlDbType.VarChar, 50),
new SqlParameter("@p100", SqlDbType.Decimal, 9),
new SqlParameter("@p101", SqlDbType.Decimal, 9),
new SqlParameter("@p102", SqlDbType.Decimal, 9),
new SqlParameter("@p103", SqlDbType.Decimal, 9),
new SqlParameter("@p104", SqlDbType.Decimal, 9),
new SqlParameter("@p105", SqlDbType.Decimal, 9),
new SqlParameter("@p106", SqlDbType.Decimal, 9),
new SqlParameter("@p107", SqlDbType.Decimal, 9),
new SqlParameter("@p108", SqlDbType.Decimal, 9),
new SqlParameter("@p109", SqlDbType.Decimal, 9),
new SqlParameter("@p110", SqlDbType.Decimal, 9),
new SqlParameter("@p111", SqlDbType.Decimal, 9),
new SqlParameter("@p112", SqlDbType.Decimal, 9),
new SqlParameter("@p113", SqlDbType.Decimal, 9),
new SqlParameter("@p114", SqlDbType.Decimal, 9),
new SqlParameter("@p115", SqlDbType.Decimal, 9),
new SqlParameter("@p116", SqlDbType.Decimal, 9),
new SqlParameter("@p117", SqlDbType.Decimal, 9),
new SqlParameter("@p118", SqlDbType.Decimal, 9),
new SqlParameter("@p119", SqlDbType.Decimal, 9),
new SqlParameter("@p300", SqlDbType.Decimal, 9),
new SqlParameter("@p200", SqlDbType.Decimal, 9),
new SqlParameter("@p201", SqlDbType.Decimal, 9),
new SqlParameter("@p202", SqlDbType.Decimal, 9),
new SqlParameter("@p203", SqlDbType.Decimal, 9),
new SqlParameter("@p204", SqlDbType.Decimal, 9),
new SqlParameter("@p205", SqlDbType.Decimal, 9),
new SqlParameter("@p207", SqlDbType.Decimal, 9),
new SqlParameter("@p208", SqlDbType.Decimal, 9),
new SqlParameter("@p209", SqlDbType.Decimal, 9),
new SqlParameter("@p210", SqlDbType.Decimal, 9),
new SqlParameter("@p206", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.id;
parameters[1].Value = model.rateType;
parameters[2].Value = model.billId;
parameters[3].Value = model.billame;
parameters[4].Value = model.p100;
parameters[5].Value = model.p101;
parameters[6].Value = model.p102;
parameters[7].Value = model.p103;
parameters[8].Value = model.p104;
parameters[9].Value = model.p105;
parameters[10].Value = model.p106;
parameters[11].Value = model.p107;
parameters[12].Value = model.p108;
parameters[13].Value = model.p109;
parameters[14].Value = model.p110;
parameters[15].Value = model.p111;
parameters[16].Value = model.p112;
parameters[17].Value = model.p113;
parameters[18].Value = model.p114;
parameters[19].Value = model.p115;
parameters[20].Value = model.p116;
parameters[21].Value = model.p117;
parameters[22].Value = model.p118;
parameters[23].Value = model.p119;
parameters[24].Value = model.p300;
parameters[25].Value = model.p200;
parameters[26].Value = model.p201;
parameters[27].Value = model.p202;
parameters[28].Value = model.p203;
parameters[29].Value = model.p204;
parameters[30].Value = model.p205;
parameters[31].Value = model.p207;
parameters[32].Value = model.p208;
parameters[33].Value = model.p209;
parameters[34].Value = model.p210;
parameters[35].Value = model.p206;
object obj = DataBase.ExecuteScalar(CommandType.StoredProcedure, "proc_payrate_insert", parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public viviapi.Model.Finance.PayRate DataRowToModel(DataRow row)
{
viviapi.Model.Finance.PayRate model = new viviapi.Model.Finance.PayRate();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["rateType"] != null && row["rateType"].ToString() != "")
{
model.rateType = int.Parse(row["rateType"].ToString());
}
if (row["billId"] != null && row["billId"].ToString() != "")
{
model.billId = int.Parse(row["billId"].ToString());
}
if (row["billame"] != null)
{
model.billame = row["billame"].ToString();
}
if (row["p100"] != null && row["p100"].ToString() != "")
{
model.p100 = decimal.Parse(row["p100"].ToString());
}
if (row["p101"] != null && row["p101"].ToString() != "")
{
model.p101 = decimal.Parse(row["p101"].ToString());
}
if (row["p102"] != null && row["p102"].ToString() != "")
{
model.p102 = decimal.Parse(row["p102"].ToString());
}
if (row["p103"] != null && row["p103"].ToString() != "")
{
model.p103 = decimal.Parse(row["p103"].ToString());
}
if (row["p104"] != null && row["p104"].ToString() != "")
{
model.p104 = decimal.Parse(row["p104"].ToString());
}
if (row["p105"] != null && row["p105"].ToString() != "")
{
model.p105 = decimal.Parse(row["p105"].ToString());
}
if (row["p106"] != null && row["p106"].ToString() != "")
{
model.p106 = decimal.Parse(row["p106"].ToString());
}
if (row["p107"] != null && row["p107"].ToString() != "")
{
model.p107 = decimal.Parse(row["p107"].ToString());
}
if (row["p108"] != null && row["p108"].ToString() != "")
{
model.p108 = decimal.Parse(row["p108"].ToString());
}
if (row["p109"] != null && row["p109"].ToString() != "")
{
model.p109 = decimal.Parse(row["p109"].ToString());
}
if (row["p110"] != null && row["p110"].ToString() != "")
{
model.p110 = decimal.Parse(row["p110"].ToString());
}
if (row["p111"] != null && row["p111"].ToString() != "")
{
model.p111 = decimal.Parse(row["p111"].ToString());
}
if (row["p112"] != null && row["p112"].ToString() != "")
{
model.p112 = decimal.Parse(row["p112"].ToString());
}
if (row["p113"] != null && row["p113"].ToString() != "")
{
model.p113 = decimal.Parse(row["p113"].ToString());
}
if (row["p114"] != null && row["p114"].ToString() != "")
{
model.p114 = decimal.Parse(row["p114"].ToString());
}
if (row["p115"] != null && row["p115"].ToString() != "")
{
model.p115 = decimal.Parse(row["p115"].ToString());
}
if (row["p116"] != null && row["p116"].ToString() != "")
{
model.p116 = decimal.Parse(row["p116"].ToString());
}
if (row["p117"] != null && row["p117"].ToString() != "")
{
model.p117 = decimal.Parse(row["p117"].ToString());
}
if (row["p118"] != null && row["p118"].ToString() != "")
{
model.p118 = decimal.Parse(row["p118"].ToString());
}
if (row["p119"] != null && row["p119"].ToString() != "")
{
model.p119 = decimal.Parse(row["p119"].ToString());
}
if (row["p300"] != null && row["p300"].ToString() != "")
{
model.p300 = decimal.Parse(row["p300"].ToString());
}
if (row["p200"] != null && row["p200"].ToString() != "")
{
model.p200 = decimal.Parse(row["p200"].ToString());
}
if (row["p201"] != null && row["p201"].ToString() != "")
{
model.p201 = decimal.Parse(row["p201"].ToString());
}
if (row["p202"] != null && row["p202"].ToString() != "")
{
model.p202 = decimal.Parse(row["p202"].ToString());
}
if (row["p203"] != null && row["p203"].ToString() != "")
{
model.p203 = decimal.Parse(row["p203"].ToString());
}
if (row["p204"] != null && row["p204"].ToString() != "")
{
model.p204 = decimal.Parse(row["p204"].ToString());
}
if (row["p205"] != null && row["p205"].ToString() != "")
{
model.p205 = decimal.Parse(row["p205"].ToString());
}
if (row["p207"] != null && row["p207"].ToString() != "")
{
model.p207 = decimal.Parse(row["p207"].ToString());
}
if (row["p208"] != null && row["p208"].ToString() != "")
{
model.p208 = decimal.Parse(row["p208"].ToString());
}
if (row["p209"] != null && row["p209"].ToString() != "")
{
model.p209 = decimal.Parse(row["p209"].ToString());
}
if (row["p210"] != null && row["p210"].ToString() != "")
{
model.p210 = decimal.Parse(row["p210"].ToString());
}
if (row["p206"] != null && row["p206"].ToString() != "")
{
model.p206 = decimal.Parse(row["p206"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(viviapi.Model.Finance.PayRate model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update PayRate set ");
strSql.Append("rateType=@rateType,");
strSql.Append("billId=@billId,");
strSql.Append("billame=@billame,");
strSql.Append("p100=@p100,");
strSql.Append("p101=@p101,");
strSql.Append("p102=@p102,");
strSql.Append("p103=@p103,");
strSql.Append("p104=@p104,");
strSql.Append("p105=@p105,");
strSql.Append("p106=@p106,");
strSql.Append("p107=@p107,");
strSql.Append("p108=@p108,");
strSql.Append("p109=@p109,");
strSql.Append("p110=@p110,");
strSql.Append("p111=@p111,");
strSql.Append("p112=@p112,");
strSql.Append("p113=@p113,");
strSql.Append("p114=@p114,");
strSql.Append("p115=@p115,");
strSql.Append("p116=@p116,");
strSql.Append("p117=@p117,");
strSql.Append("p118=@p118,");
strSql.Append("p119=@p119,");
strSql.Append("p300=@p300,");
strSql.Append("p200=@p200,");
strSql.Append("p201=@p201,");
strSql.Append("p202=@p202,");
strSql.Append("p203=@p203,");
strSql.Append("p204=@p204,");
strSql.Append("p205=@p205,");
strSql.Append("p207=@p207,");
strSql.Append("p208=@p208,");
strSql.Append("p209=@p209,");
strSql.Append("p210=@p210,");
strSql.Append("p206=@p206");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@rateType", SqlDbType.TinyInt, 1),
new SqlParameter("@billId", SqlDbType.Int, 4),
new SqlParameter("@billame", SqlDbType.VarChar, 50),
new SqlParameter("@p100", SqlDbType.Decimal, 9),
new SqlParameter("@p101", SqlDbType.Decimal, 9),
new SqlParameter("@p102", SqlDbType.Decimal, 9),
new SqlParameter("@p103", SqlDbType.Decimal, 9),
new SqlParameter("@p104", SqlDbType.Decimal, 9),
new SqlParameter("@p105", SqlDbType.Decimal, 9),
new SqlParameter("@p106", SqlDbType.Decimal, 9),
new SqlParameter("@p107", SqlDbType.Decimal, 9),
new SqlParameter("@p108", SqlDbType.Decimal, 9),
new SqlParameter("@p109", SqlDbType.Decimal, 9),
new SqlParameter("@p110", SqlDbType.Decimal, 9),
new SqlParameter("@p111", SqlDbType.Decimal, 9),
new SqlParameter("@p112", SqlDbType.Decimal, 9),
new SqlParameter("@p113", SqlDbType.Decimal, 9),
new SqlParameter("@p114", SqlDbType.Decimal, 9),
new SqlParameter("@p115", SqlDbType.Decimal, 9),
new SqlParameter("@p116", SqlDbType.Decimal, 9),
new SqlParameter("@p117", SqlDbType.Decimal, 9),
new SqlParameter("@p118", SqlDbType.Decimal, 9),
new SqlParameter("@p119", SqlDbType.Decimal, 9),
new SqlParameter("@p300", SqlDbType.Decimal, 9),
new SqlParameter("@p200", SqlDbType.Decimal, 9),
new SqlParameter("@p201", SqlDbType.Decimal, 9),
new SqlParameter("@p202", SqlDbType.Decimal, 9),
new SqlParameter("@p203", SqlDbType.Decimal, 9),
new SqlParameter("@p204", SqlDbType.Decimal, 9),
new SqlParameter("@p205", SqlDbType.Decimal, 9),
new SqlParameter("@p207", SqlDbType.Decimal, 9),
new SqlParameter("@p208", SqlDbType.Decimal, 9),
new SqlParameter("@p209", SqlDbType.Decimal, 9),
new SqlParameter("@p210", SqlDbType.Decimal, 9),
new SqlParameter("@p206", SqlDbType.Decimal, 9),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.rateType;
parameters[1].Value = model.billId;
parameters[2].Value = model.billame;
parameters[3].Value = model.p100;
parameters[4].Value = model.p101;
parameters[5].Value = model.p102;
parameters[6].Value = model.p103;
parameters[7].Value = model.p104;
parameters[8].Value = model.p105;
parameters[9].Value = model.p106;
parameters[10].Value = model.p107;
parameters[11].Value = model.p108;
parameters[12].Value = model.p109;
parameters[13].Value = model.p110;
parameters[14].Value = model.p111;
parameters[15].Value = model.p112;
parameters[16].Value = model.p113;
parameters[17].Value = model.p114;
parameters[18].Value = model.p115;
parameters[19].Value = model.p116;
parameters[20].Value = model.p117;
parameters[21].Value = model.p118;
parameters[22].Value = model.p119;
parameters[23].Value = model.p300;
parameters[24].Value = model.p200;
parameters[25].Value = model.p201;
parameters[26].Value = model.p202;
parameters[27].Value = model.p203;
parameters[28].Value = model.p204;
parameters[29].Value = model.p205;
parameters[30].Value = model.p207;
parameters[31].Value = model.p208;
parameters[32].Value = model.p209;
parameters[33].Value = model.p210;
parameters[34].Value = model.p206;
parameters[35].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(viviapi.Model.Finance.PayRate model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into PayRate(");
strSql.Append("rateType,billId,billame,p100,p101,p102,p103,p104,p105,p106,p107,p108,p109,p110,p111,p112,p113,p114,p115,p116,p117,p118,p119,p300,p200,p201,p202,p203,p204,p205,p207,p208,p209,p210,p206)");
strSql.Append(" values (");
strSql.Append("@rateType,@billId,@billame,@p100,@p101,@p102,@p103,@p104,@p105,@p106,@p107,@p108,@p109,@p110,@p111,@p112,@p113,@p114,@p115,@p116,@p117,@p118,@p119,@p300,@p200,@p201,@p202,@p203,@p204,@p205,@p207,@p208,@p209,@p210,@p206)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@rateType", SqlDbType.TinyInt, 1),
new SqlParameter("@billId", SqlDbType.Int, 4),
new SqlParameter("@billame", SqlDbType.VarChar, 50),
new SqlParameter("@p100", SqlDbType.Decimal, 9),
new SqlParameter("@p101", SqlDbType.Decimal, 9),
new SqlParameter("@p102", SqlDbType.Decimal, 9),
new SqlParameter("@p103", SqlDbType.Decimal, 9),
new SqlParameter("@p104", SqlDbType.Decimal, 9),
new SqlParameter("@p105", SqlDbType.Decimal, 9),
new SqlParameter("@p106", SqlDbType.Decimal, 9),
new SqlParameter("@p107", SqlDbType.Decimal, 9),
new SqlParameter("@p108", SqlDbType.Decimal, 9),
new SqlParameter("@p109", SqlDbType.Decimal, 9),
new SqlParameter("@p110", SqlDbType.Decimal, 9),
new SqlParameter("@p111", SqlDbType.Decimal, 9),
new SqlParameter("@p112", SqlDbType.Decimal, 9),
new SqlParameter("@p113", SqlDbType.Decimal, 9),
new SqlParameter("@p114", SqlDbType.Decimal, 9),
new SqlParameter("@p115", SqlDbType.Decimal, 9),
new SqlParameter("@p116", SqlDbType.Decimal, 9),
new SqlParameter("@p117", SqlDbType.Decimal, 9),
new SqlParameter("@p118", SqlDbType.Decimal, 9),
new SqlParameter("@p119", SqlDbType.Decimal, 9),
new SqlParameter("@p300", SqlDbType.Decimal, 9),
new SqlParameter("@p200", SqlDbType.Decimal, 9),
new SqlParameter("@p201", SqlDbType.Decimal, 9),
new SqlParameter("@p202", SqlDbType.Decimal, 9),
new SqlParameter("@p203", SqlDbType.Decimal, 9),
new SqlParameter("@p204", SqlDbType.Decimal, 9),
new SqlParameter("@p205", SqlDbType.Decimal, 9),
new SqlParameter("@p207", SqlDbType.Decimal, 9),
new SqlParameter("@p208", SqlDbType.Decimal, 9),
new SqlParameter("@p209", SqlDbType.Decimal, 9),
new SqlParameter("@p210", SqlDbType.Decimal, 9),
new SqlParameter("@p206", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.rateType;
parameters[1].Value = model.billId;
parameters[2].Value = model.billame;
parameters[3].Value = model.p100;
parameters[4].Value = model.p101;
parameters[5].Value = model.p102;
parameters[6].Value = model.p103;
parameters[7].Value = model.p104;
parameters[8].Value = model.p105;
parameters[9].Value = model.p106;
parameters[10].Value = model.p107;
parameters[11].Value = model.p108;
parameters[12].Value = model.p109;
parameters[13].Value = model.p110;
parameters[14].Value = model.p111;
parameters[15].Value = model.p112;
parameters[16].Value = model.p113;
parameters[17].Value = model.p114;
parameters[18].Value = model.p115;
parameters[19].Value = model.p116;
parameters[20].Value = model.p117;
parameters[21].Value = model.p118;
parameters[22].Value = model.p119;
parameters[23].Value = model.p300;
parameters[24].Value = model.p200;
parameters[25].Value = model.p201;
parameters[26].Value = model.p202;
parameters[27].Value = model.p203;
parameters[28].Value = model.p204;
parameters[29].Value = model.p205;
parameters[30].Value = model.p207;
parameters[31].Value = model.p208;
parameters[32].Value = model.p209;
parameters[33].Value = model.p210;
parameters[34].Value = model.p206;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
