/// <summary>
/// 增、改K_Types表
/// </summary>
/// <param name="tranType">操作类型，NEW=增，EDIT=改</param>
/// <param name="paramsModel"></param>
/// <returns>返回大于0的数字操作正常，返回非数字表示操作错误，返回的是系统错误说明</returns>
public string Save(string tranType, KingTop.Model.Types paramsModel)
{
string isOk = "";
try
{
SqlParameter returnValue = new SqlParameter("@ReturnValue", SqlDbType.Int, 4);
returnValue.Direction = ParameterDirection.Output;
string cmdText = "proc_K_TypesSave";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("tranType", tranType),
new SqlParameter("TypeId", paramsModel.TypeId),
new SqlParameter("TypeName", paramsModel.TypeName),
new SqlParameter("TypeParent", paramsModel.TypeParent),
new SqlParameter("Orders", paramsModel.Orders),
new SqlParameter("AddDate", paramsModel.AddDate),
new SqlParameter("MenuID", paramsModel.MenuID),
new SqlParameter("IsPub", paramsModel.IsPub),
new SqlParameter("Digest", paramsModel.Digest),
new SqlParameter("MenuString", paramsModel.MenuString),
new SqlParameter("TypeExpandInt", paramsModel.TypeExpandInt),
new SqlParameter("TypeExpandChar1", paramsModel.TypeExpandChar1),
new SqlParameter("TypeExpandChar2", paramsModel.TypeExpandChar2),
new SqlParameter("TypeExpandChar3", paramsModel.TypeExpandChar3),
returnValue
};
SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, cmdText, paras);
isOk = returnValue.Value.ToString();
}
catch (Exception ex)
{
isOk = ex.Message;
}
return(isOk);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
KingTop.Model.Types modpt = new KingTop.Model.Types();
KingTop.BLL.Types bllpt = new KingTop.BLL.Types();
string typename = Request.Form["txtName"];
string typeorders = Request.Form["txtOrd"];
string typecon = Request.Form["txtDigest"];
modpt.TypeName = typename;
modpt.Orders = Convert.ToInt32(typeorders);
modpt.AddDate = DateTime.Now;
modpt.MenuID = MenuID;
modpt.TypeExpandChar1 = txtCurrentImg.Text;
modpt.Digest = typecon;
if (RadioButton1.Checked)
{
modpt.TypeExpandInt = 1;
}
else
{
modpt.TypeExpandInt = 0;
}
if (RadioButton2.Checked)
{
modpt.IsPub = 1;
}
else
{
modpt.IsPub = 0;
}
if (action == "New")//新增页面样式设定
{
modsel.S1 = typeid;
modpt.TypeParent = typeid;
DataTable dt = bllpt.GetList("MAXID", modsel);
string typeids1 = "";
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["TypeId"].ToString() == "")
{
typeids1 = typeid + "001";
}
else
{
typeids1 = KingTop.Common.Tools.SubStr(dt.Rows[0]["TypeId"].ToString(), dt.Rows[0]["TypeId"].ToString().Length - 3, ""); //截取去掉最后三位数的数字的字符串
//int TypeLast3num = Convert.ToInt32(dt.Rows[0]["TypeId"].ToString().Replace(KingTop.Common.Tools.SubStr(dt.Rows[0]["TypeId"].ToString(), dt.Rows[0]["TypeId"].ToString().Length - 3, ""), "").Replace("0", "")) + 1; // 1 获取最后三位数 2 软换为int类型再加一
int TypeLast3num = Convert.ToInt32(dt.Rows[0]["TypeId"].ToString().Replace(KingTop.Common.Tools.SubStr(dt.Rows[0]["TypeId"].ToString(), dt.Rows[0]["TypeId"].ToString().Length - 3, ""), "")) + 1; // 1 获取最后三位数 2 软换为int类型再加一
#region 对最后三位数进行处理(加上0，确保计算后的数是由三个数字组成 例如 "001")
string TypeLast3numString = "";
if (TypeLast3num.ToString().Length == 1)
{
TypeLast3numString = "00" + TypeLast3num;
}
else if (TypeLast3num.ToString().Length == 2)
{
TypeLast3numString = "0" + TypeLast3num;
}
else
{
TypeLast3numString = TypeLast3num.ToString();
}
#endregion
typeids1 = typeids1 + TypeLast3numString; //最后把这两组字符串组合起来
//typeids1 = Convert.ToString(Convert.ToDouble(dt.Rows[0]["TypeId"].ToString()) + 1);
}
}
else
{
typeids1 = typeid + "001";
}
//typeids = typeids1;
modpt.TypeId = typeids1;
string result = bllpt.Save("NEW", modpt);
if (result == "1")
{
Response.Redirect("typeclasslist.aspx?NodeCode=" + MenuID + "");
}
Response.Redirect("typeclasslist.aspx?NodeCode=" + MenuID + "");
}
if (action == "Edit")//更新页面样式设定
{
modpt.TypeId = typeid;
modpt.TypeParent = typeparent;
string result = bllpt.Save("EDIT", modpt);
if (result == "1")
{
Response.Redirect("typeclasslist.aspx?NodeCode=" + MenuID + "");
}
Response.Redirect("typeclasslist.aspx?NodeCode=" + MenuID + "");
}
}
/// <summary>
/// 增、改K_Types表
/// </summary>
/// <param name="tranType">操作类型，NEW=增，EDIT=改</param>
/// <param name="TypModel"></param>
/// <returns>返回大于0的数字操作正常，返回非数字表示操作错误，返回的是系统错误说明</returns>
public string Save(string trantype, KingTop.Model.Types typModel)
{
return(dal.Save(trantype, typModel));
}
