/// <summary>
/// 设置读者级别
/// </summary>
/// <param name="i">1代表修改</param>
/// <param name="su"></param>
/// <returns></returns>
public static string sysSetUp(int i, Model.SetUp su)
{
string str = "prco_ReadStandardSave";
SqlParameter[] Parameter =
{
new SqlParameter("@num", SqlDbType.Int),
new SqlParameter("@读者级别", SqlDbType.Int),
new SqlParameter("@可借天数", SqlDbType.Int),
new SqlParameter("@可借最高级别", SqlDbType.Int),
new SqlParameter("@可借本数", SqlDbType.Int),
new SqlParameter("@backvalue", SqlDbType.NVarChar, 20)
};
Parameter[0].Value = i;
Parameter[1].Value = su.CbReadLevel;
Parameter[2].Value = su.NudReadDateNum;
Parameter[3].Value = su.CbReadMaxLevel;
Parameter[4].Value = su.NudBookNum;
Parameter[5].Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, str, Parameter);
return(Convert.ToString(Parameter[5].Value.ToString()));
}
//--------------------------------------------------------------------------------------------------
//罚款确定
private void btnFineOk_Click(object sender, EventArgs e)
{
try
{
Model.SetUp su = new Model.SetUp();
su.TbFineBook = Convert.ToDecimal(this.tbFineBook.Text);
su.TbFineDate = Convert.ToDecimal(this.tbFineDate.Text);
su.TbFineLost = Convert.ToInt32(this.tbFineLost.Value);
BLL.SetUpBLL.sysFine(1, su);
//关闭窗体
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//罚款应用
private void btnFineApp_Click(object sender, EventArgs e)
{
try
{
this.btnFineApp.Enabled = false;
Model.SetUp su = new Model.SetUp();
su.TbFineBook = Convert.ToDecimal(this.tbFineBook.Text);
su.TbFineDate = Convert.ToDecimal(this.tbFineDate.Text);
su.TbFineLost = Convert.ToInt32(this.tbFineLost.Value);
string a = BLL.SetUpBLL.sysFine(1, su);
MessageBox.Show(a, "提示");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//确定
private void btnSetUpOK_Click(object sender, EventArgs e)
{
try
{
Model.SetUp su = new Model.SetUp();
su.CbReadLevel = Convert.ToInt32(this.cbReadLevel.Text);
su.NudReadDateNum = Convert.ToInt32(this.nudReadDateNum.Value);
su.CbReadMaxLevel = Convert.ToInt32(this.cbReadMaxLevel.Text);
su.NudBookNum = Convert.ToInt32(this.nudBookNum.Value);
BLL.SetUpBLL.sysSetUp(1, su);
//关闭窗体
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//应用
private void btnSetUpApp_Click(object sender, EventArgs e)
{
try
{
//禁用
this.btnSetUpApp.Enabled = false;
Model.SetUp su = new Model.SetUp(); //实体类 封装数据
su.CbReadLevel = Convert.ToInt32(this.cbReadLevel.Text);
su.NudReadDateNum = Convert.ToInt32(this.nudReadDateNum.Value);
su.CbReadMaxLevel = Convert.ToInt32(this.cbReadMaxLevel.Text);
su.NudBookNum = Convert.ToInt32(this.nudBookNum.Value);
string a = BLL.SetUpBLL.sysSetUp(1, su); //业务处理层 返回处理完的值
MessageBox.Show(a, "提示");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 设置罚款单价
/// </summary>
/// <param name="i">1代表修改</param>
/// <param name="su"></param>
/// <returns></returns>
public static string sysFine(int i, Model.SetUp su)
{
string str = "proc_FineStandardSave";
SqlParameter[] Parameter =
{
new SqlParameter("@num", SqlDbType.Int),
new SqlParameter("@逾期单价", SqlDbType.Decimal),
new SqlParameter("@损坏单价", SqlDbType.Decimal),
new SqlParameter("@丢失单价", SqlDbType.TinyInt),
new SqlParameter("@backvalue", SqlDbType.NVarChar, 20)
};
Parameter[0].Value = i;
Parameter[1].Value = su.TbFineDate;
Parameter[2].Value = su.TbFineBook;
Parameter[3].Value = su.TbFineLost;
Parameter[4].Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, str, Parameter);
return(Convert.ToString(Parameter[4].Value.ToString()));
}
