/// <summary>
/// 点击确定按钮处理事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
string newAmount = txtNewAmount.Text;
string commAmount = txtCommAmount.Text;
string tradeAmount = txtTradedAmount.Text;
string tradeMoney = txtTradedMoney.Text;
if (newAmount == "" || commAmount == "" || tradeAmount == "" || tradeMoney == "")
{
MLMGC.COMP.Jscript.ShowMsg("请认真填写以上内容", this);
return;
}
E_Standard data = new E_Standard();
data.EnterpriseID = EnterpriceID;
data.NewAmount = Convert.ToInt32(newAmount);
data.CommAmount = Convert.ToInt32(commAmount);
data.TradedAmount = Convert.ToInt32(tradeAmount);
data.TradedMoney = Convert.ToSingle(tradeMoney);
bool flag = new T_Standard().Update(data);
new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log()
{
EnterpriseID = EnterpriceID, UserID = UserID, LogTitle = "最低标准设置", IP = MLMGC.COMP.Requests.GetRealIP()
});
if (flag)
{
MLMGC.COMP.Jscript.ShowMsg("操作成功", this);
}
else
{
MLMGC.COMP.Jscript.ShowMsg("操作失败", this);
}
}
protected void databind()
{
E_Standard data = new E_Standard();
data.EnterpriseID = EnterpriceID;
data = new T_Standard().GetModel(data);
if (data == null)
{
return;
}
txtNewAmount.Text = data.NewAmount.ToString();
txtCommAmount.Text = data.CommAmount.ToString();
txtTradedAmount.Text = data.TradedAmount.ToString();
txtTradedMoney.Text = data.TradedMoney.ToString("f2");
}
/// <summary>
/// 得到企业最低标准对象
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-10-18</remarks>
public E_Standard GetModel(E_Standard data)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@EnterpriseID", SqlDbType.Int)
};
parms[0].Value = data.EnterpriseID;
DataTable dt = DbHelperSQL.RunProcedureTable("ProcEP_B_Standard_Select", parms);
if (dt != null && dt.Rows.Count == 1)
{
data.NewAmount = Convert.ToInt32(dt.Rows[0]["NewAmount"]);
data.CommAmount = Convert.ToInt32(dt.Rows[0]["CommAmount"]);
data.TradedAmount = Convert.ToInt32(dt.Rows[0]["TradedAmount"]);
data.TradedMoney = Convert.ToSingle(dt.Rows[0]["TradedMoney"]);
return(data);
}
return(null);
}
/// <summary>
/// 添加或更新最低标准
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks >tianzhenyun 2011-10-18</remarks>
public bool Update(E_Standard data)
{
int rowsAffected = 0;
//参数列表
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@EnterpriseID", SqlDbType.Int),
new SqlParameter("@NewAmount", SqlDbType.Int),
new SqlParameter("@CommAmount", SqlDbType.Int),
new SqlParameter("@TradedAmount", SqlDbType.Int),
new SqlParameter("@TradedMoney", SqlDbType.Money)
};
parms[0].Value = data.EnterpriseID;
parms[1].Value = data.NewAmount;
parms[2].Value = data.CommAmount;
parms[3].Value = data.TradedAmount;
parms[4].Value = data.TradedMoney;
DbHelperSQL.ExecProcedure("ProcEP_B_Standard_Update", parms, out rowsAffected);
return(rowsAffected > 0);
}
/// <summary>
/// 查询企业最低标准
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public E_Standard GetModel(E_Standard data)
{
return(dal.GetModel(data));
}
/// <summary>
/// 添加或更新最低标准
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public bool Update(E_Standard data)
{
return(dal.Update(data));
}
