/// <summary>
/// 添加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Save_Click(object sender, ImageClickEventArgs e)
{
int num = 0;
if (Request.QueryString["id"] != "" && Request.QueryString["id"] != null)
{
int id = Convert.ToInt32(Request.QueryString["id"]);
mod = ProductParamBLL.GetmodByid(id);
mod.ParamContent = txtparamContent.Text.Trim();
num = ProductParamBLL.Updatemod(mod);
}
else
{
mod = new ProductParamMOD();
mod.CustomNo = txtcustomerNo.Text.Trim();
mod.ParamContent = txtparamContent.Text.Trim();
mod.ProductNo = txtproductNO.Text.Trim();
num = ProductParamBLL.Insertmod(mod);
}
if (num > 0)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "DetailsPageControl.CloseBox();alert('提交成功');DetailsPageControl.ReflushList('CustomerManage/ProductParamManage.aspx');", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "alert('提交失败');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["id"] != "" && Request.QueryString["id"] != null)
{
int id = Convert.ToInt32(Request.QueryString["id"]);
mod = ProductParamBLL.GetmodByid(id);
if (mod != null)
{
//加载客户信息
txtcustomerNo.Text = mod.CustomNo;
txtparamContent.Text = mod.ParamContent;
txtproductNO.Text = mod.ProductNo;
}
//客户编号不允许修改
txtcustomerNo.Enabled = false;
txtproductNO.Enabled = false;
}
}
}
/// <summary>
/// 根据主键id查询信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static ProductParamMOD GetmodByid(int id)
{
ProductParamMOD mod = new ProductParamMOD();
string sqlcommandString = "select * from ProductParam where paramId=" + id;
try
{
SqlDataReader reader = SqlHelper.ExecuteReader(sqlcommandString);
if (reader.Read())
{
mod.ProductNo = reader["ProductNo"].ToString();
mod.CustomNo = reader["CustomNo"].ToString();
mod.ParamId = Convert.ToInt32(reader["ParamId"].ToString());
mod.ParamContent = reader["ParamContent"].ToString();
if (reader["IsWriteFahuoInfo"] != null && reader["IsWriteFahuoInfo"].ToString() != "")
{
mod.IsWriteFahuoInfo = Convert.ToInt32(reader["IsWriteFahuoInfo"]);
}
if (reader["IsWriteXianChang"] != null && reader["IsWriteXianChang"].ToString() != "")
{
mod.IsWriteXianChang = Convert.ToInt32(reader["IsWriteXianChang"]);
}
mod.Wuliaobian = reader["wuliaobian"].ToString();
reader.Close();
return mod;
}
else
{
reader.Close();
return null;
}
}
catch (Exception e)
{
throw e;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["id"] != "" && Request.QueryString["id"] != null)
{
int id = Convert.ToInt32(Request.QueryString["id"]);
mod = ProductParamBLL.GetmodByid(id);
if (mod != null)
{
//加载客户信息
txtcustomerNo.Text = mod.CustomNo;
txtparamContent.Text = mod.ParamContent;
txtproductNO.Text = mod.ProductNo;
txtWuliaobian.Text = mod.Wuliaobian;
if (mod.IsWriteFahuoInfo != null && mod.IsWriteFahuoInfo.ToString() != "")
{
switch (mod.IsWriteFahuoInfo)
{
case 0:
rdoCusYes.Checked = false;
rdoCusNo.Checked = true;
break;
case 1:
rdoCusYes.Checked = true;
rdoCusNo.Checked = false;
break;
default:
rdoCusYes.Checked = false;
rdoCusNo.Checked = false;
break;
}
}
else
{
rdoCusYes.Checked = false;
rdoCusNo.Checked = false;
}
if (mod.IsWriteXianChang != null && mod.IsWriteXianChang.ToString() != "")
{
switch (mod.IsWriteXianChang)
{
case 0:
rdoProYes.Checked = false;
rdoProNo.Checked = true;
break;
case 1:
rdoProYes.Checked = true;
rdoProNo.Checked = false;
break;
default:
rdoProYes.Checked = false;
rdoProNo.Checked = false;
break;
}
}
else
{
rdoProYes.Checked = false;
rdoProNo.Checked = false;
}
}
//客户编号不允许修改
txtcustomerNo.Enabled = false;
txtproductNO.Enabled = false;
}
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Save_Click(object sender, ImageClickEventArgs e)
{
int num = 0;
if (Request.QueryString["id"] != "" && Request.QueryString["id"] != null)
{
int id = Convert.ToInt32(Request.QueryString["id"]);
mod = ProductParamBLL.GetmodByid(id);
mod.ParamContent = txtparamContent.Text.Trim();
if (rdoCusYes.Checked)
{
mod.IsWriteFahuoInfo = 1;
}
else
{
mod.IsWriteFahuoInfo = 0;
}
if (rdoProYes.Checked)
{
mod.IsWriteXianChang = 1;
}
else
{
mod.IsWriteXianChang = 0;
}
mod.Wuliaobian = txtWuliaobian.Text.Trim();
num = ProductParamBLL.Updatemod(mod);
}
else
{
mod = ProductParamBLL.GetmodByid(txtcustomerNo.Text.Trim(), txtproductNO.Text.Trim());
if (mod != null)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "alert('该客户的产品参数已存在！');", true);
return;
}
else
{
mod = new ProductParamMOD();
mod.CustomNo = txtcustomerNo.Text.Trim();
mod.ParamContent = txtparamContent.Text.Trim();
mod.ProductNo = txtproductNO.Text.Trim();
mod.Wuliaobian = txtWuliaobian.Text.Trim();
if (rdoCusYes.Checked)
{
mod.IsWriteFahuoInfo = 1;
}
else
{
mod.IsWriteFahuoInfo = 0;
}
if (rdoProYes.Checked)
{
mod.IsWriteXianChang = 1;
}
else
{
mod.IsWriteXianChang = 0;
}
num = ProductParamBLL.Insertmod(mod);
}
}
if (num > 0)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "DetailsPageControl.CloseBox();alert('提交成功');DetailsPageControl.ReflushList('CustomerManage/ProductParamManage.aspx');", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "alert('提交失败');", true);
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="dtomodList">数据对象</param>
/// <returns></returns>
public static int Updatemod(ProductParamMOD mod)
{
return ProductParamDAO.Updatemod(mod);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="dtomodList">对象</param>
/// <returns></returns>
public static int Insertmod(ProductParamMOD mod)
{
return ProductParamDAO.Insertmod(mod);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="dtomodList">数据对象</param>
/// <returns></returns>
public static int Updatemod(ProductParamMOD mod)
{
string sqlCommandString = "Update ProductParam Set paramContent=@paramContent,isWriteFahuoInfo=@isWriteFahuoInfo,isWriteXianChang=@isWriteXianChang,wuliaobian=@wuliaobian Where paramId=@paramId";
SqlParameter[] arParams = new SqlParameter[5];
arParams[0] = new SqlParameter("@paramId", mod.ParamId);
arParams[1] = new SqlParameter("@paramContent", mod.ParamContent);
arParams[2] = new SqlParameter("@isWriteFahuoInfo", mod.IsWriteFahuoInfo);
arParams[3] = new SqlParameter("@isWriteXianChang", mod.IsWriteXianChang);
arParams[4] = new SqlParameter("@wuliaobian", mod.Wuliaobian);
return SqlHelper.ExecuteNonQuery(CommandType.Text, sqlCommandString, arParams);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="dtomodList">对象</param>
/// <returns></returns>
public static int Insertmod(ProductParamMOD mod)
{
string sqlCommandString = "Insert Into ProductParam(customNo,productNo,paramContent,isWriteFahuoInfo,isWriteXianChang,wuliaobian)Values(@customNo,@productNo,@paramContent,@isWriteFahuoInfo,@isWriteXianChang,@wuliaobian)";
SqlParameter[] arParams = new SqlParameter[6];
arParams[0] = new SqlParameter("@customNo", mod.CustomNo);
arParams[1] = new SqlParameter("@productNo", mod.ProductNo);
arParams[2] = new SqlParameter("@paramContent", mod.ParamContent);
arParams[3] = new SqlParameter("@isWriteFahuoInfo", mod.IsWriteFahuoInfo);
arParams[4] = new SqlParameter("@isWriteXianChang", mod.IsWriteXianChang);
arParams[5] = new SqlParameter("@wuliaobian",mod.Wuliaobian);
return SqlHelper.ExecuteNonQuery(CommandType.Text, sqlCommandString, arParams);
}
