public static bool UpdateDefaultMember(Model.DefaultMessage def)
{
using (SqlConnection conn = new SqlConnection(DBHelper.connString))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
if (!DAL.ManageDAL.InsertUpaDetails(def, tran))
{
tran.Rollback();
return(false);
}
if (!DAL.ManageDAL.UpdateMemberId(def.NewId, def.OldId, tran))
{
tran.Rollback();
return(false);
}
tran.Commit();
return(true);
}
catch
{
tran.Rollback();
return(false);
}
finally
{
conn.Close();
}
}
}
protected void Button3_Click(object sender, EventArgs e)
{
int nowExpectNum = BLL.CommonClass.CommonDataBLL.getMaxqishu();
if (nowExpectNum != 1)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("007094", "只有在第一期时才能初始化！") + "');</script>");
return;
}
txtMemberId.Text = DisposeString.DisString(txtMemberId.Text.Trim());
int count = BLL.CommonClass.CommonDataBLL.getCountNumber(txtMemberId.Text.Trim());
if (count > 0)
{
Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert("该会员编号已存在！"));
return;
}
Model.DefaultMessage def = GetModel(3, txtMemberId.Text.Trim());
bool isSure = ManagerBLL.UpdateDefaultMember(def);
if (!isSure)
{
Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert("修改失败！"));
return;
}
Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('修改成功！');</script>");
}
public static bool InsertUpaDetails(Model.DefaultMessage def, SqlTransaction tran)
{
string sql = @"Insert Into UpdDefaultDedails(ExpectNum,OldId,NewId,OperateIp,OperateNum,UpdateTime,Type) values(@ExpectNum,@OldId,@NewId,@OperateIp,@OperateNum,@UpdateTime,@Type)";
SqlParameter[] para =
{
new SqlParameter("@ExpectNum", SqlDbType.Int),
new SqlParameter("@OldId", SqlDbType.NVarChar, 30),
new SqlParameter("@NewId", SqlDbType.NVarChar, 30),
new SqlParameter("@OperateIp", SqlDbType.NVarChar, 30),
new SqlParameter("@OperateNum", SqlDbType.NVarChar, 30),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@Type", SqlDbType.Int)
};
para[0].Value = def.ExpectNum;
para[1].Value = def.OldId;
para[2].Value = def.NewId;
para[3].Value = def.OperateIp;
para[4].Value = def.OperateNum;
para[5].Value = def.UpdateTime;
para[6].Value = def.Type;
int count = (int)DBHelper.ExecuteNonQuery(tran, sql, para, CommandType.Text);
if (count == 0)
{
return(false);
}
return(true);
}
protected void Button1_Click(object sender, EventArgs e)
{
txtManageId.Text = DisposeString.DisString(txtManageId.Text.Trim());
Model.DefaultMessage def = GetModel(1, txtManageId.Text.Trim());
bool isSure = ManagerBLL.UpdateDefaultManage(def);
if (!isSure)
{
Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert("修改失败！"));
return;
}
Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('修改成功，请重新登录！');top.location.href('../logout.aspx')</script>");
}
