/// <summary>
/// 根据主键id查询信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static MattersNeedingAttentionMOD GetmodByid(int id)
{
MattersNeedingAttentionMOD mod = new MattersNeedingAttentionMOD();
string sqlcommandString = "select * from MattersNeedingAttention where id=" + id;
try
{
SqlDataReader reader = SqlHelper.ExecuteReader(sqlcommandString);
if (reader.Read())
{
mod.Contents = reader["Contents"].ToString();
mod.CustomerNo = reader["CustomerNo"].ToString();
mod.Id = Convert.ToInt32(reader["Id"].ToString());
}
reader.Close();
return mod;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Save_Click(object sender, EventArgs e)
{
int num = 0;
if (Request.QueryString["customerNo"] != null && Request.QueryString["customerNo"].ToString() != "")
{
customerNo = Request.QueryString["customerNo"].ToString();
MattersNeedingAttentionMOD mod = MattersNeedingAttentionBLL.GetmodByid(customerNo);
if (mod != null)
{
mod.Contents = txtContents.Text;
num = MattersNeedingAttentionBLL.Updatemod(mod);
}
}
else
{
MattersNeedingAttentionMOD mod = new MattersNeedingAttentionMOD();
mod.CustomerNo = txtCustomerNo.Text.Trim();
mod.Contents = txtContents.Text.Trim();
num = MattersNeedingAttentionBLL.Insertmod(mod);
}
if (num > 0)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "DetailsPageControl.CloseBox();alert('提交成功');DetailsPageControl.ReflushList('CustomerManage/ZYSXManage.aspx')", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "DetailsPageControl.CloseBox();alert('提交失败');", true);
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="dtomodList">数据对象</param>
/// <returns></returns>
public static int Updatemod(MattersNeedingAttentionMOD mod)
{
return MattersNeedingAttentionDAO.Updatemod(mod);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="dtomodList">对象</param>
/// <returns></returns>
public static int Insertmod(MattersNeedingAttentionMOD mod)
{
return MattersNeedingAttentionDAO.Insertmod(mod);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="dtomodList">数据对象</param>
/// <returns></returns>
public static int Updatemod(MattersNeedingAttentionMOD mod)
{
string sqlCommandString = "Update MattersNeedingAttention Set contents=@contents Where id=@id";
SqlParameter[] arParams = new SqlParameter[2];
arParams[0] = new SqlParameter("@id", mod.Id);
arParams[1] = new SqlParameter("@contents", mod.Contents);
return SqlHelper.ExecuteNonQuery(CommandType.Text, sqlCommandString, arParams);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="dtomodList">对象</param>
/// <returns></returns>
public static int Insertmod(MattersNeedingAttentionMOD mod)
{
string sqlCommandString = "Insert Into MattersNeedingAttention(customerNo,contents)Values(@customerNo,@contents)";
SqlParameter[] arParams = new SqlParameter[2];
arParams[0] = new SqlParameter("@customerNo", mod.CustomerNo);
arParams[1] = new SqlParameter("@contents", mod.Contents);
return SqlHelper.ExecuteNonQuery(CommandType.Text, sqlCommandString, arParams);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Save_Click(object sender, EventArgs e)
{
int num = 0;
MattersNeedingAttentionMOD mod = new MattersNeedingAttentionMOD();
mod.CustomerNo = txtCustomerNo.Text.Trim();
mod.Contents = txtContents.Text.Trim();
num = MattersNeedingAttentionBLL.Insertmod(mod);
if (num > 0)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "alert('提交成功');DetailsPageControl.ReflushList('CustomerManage/ZYSXManage.aspx')", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "alert('提交失败');", true);
}
LoadDataBind(strWhere);
}
