/// <summary>
/// 编辑计量单位
/// </summary>
private void EditBaseUnit()
{
ManagerHelper.CheckPrivilege(Privilege.UnitsEdit);
BaseUnitsInfo baseUnitsInfo = this.GetBaseUnitsInfo();
if (baseUnitsInfo == null || !this.ValidationUnit(baseUnitsInfo))
{
return;
}
var member = HiContext.Current.User;
if (member == null || member.IsLockedOut)
{
return;
}
baseUnitsInfo.UpdateUser = member.Username + "_" + member.UserId;
baseUnitsInfo.ID = this.unitId;
if (CatalogHelper.IsExistUnit(baseUnitsInfo.HSJoinID, baseUnitsInfo.Name_CN, this.unitId))
{
this.ShowMsg("海关代码或计量单位名称已存在，请重新填写", true);
return;
}
if (CatalogHelper.EditUnit(baseUnitsInfo))
{
base.Response.Redirect(Globals.GetAdminAbsolutePath("/product/BaseUnits.aspx"), true);
return;
}
this.ShowMsg("编辑计量单位失败", true);
return;
}
/// <summary>
/// 编辑计量单位
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool EditUnit(BaseUnitsInfo model)
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("Update dbo.Ecshop_BaseUnits set HSJoinID=@HSJoinID, Name_CN=@Name_CN,UpdateUser=@UpdateUser,UpdateTime=getdate() where id=@id");
this.database.AddInParameter(sqlStringCommand, "HSJoinID", DbType.String, model.HSJoinID);
this.database.AddInParameter(sqlStringCommand, "Name_CN", DbType.String, model.Name_CN);
this.database.AddInParameter(sqlStringCommand, "UpdateUser", DbType.String, model.UpdateUser);
this.database.AddInParameter(sqlStringCommand, "id", DbType.Int32, model.ID);
return(this.database.ExecuteNonQuery(sqlStringCommand) > 0);
}
/// <summary>
/// 新增计量单位
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddUnit(BaseUnitsInfo model)
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("DECLARE @DisplaySequence AS INT SELECT @DisplaySequence = (CASE WHEN MAX(Sort) IS NULL THEN 1 ELSE MAX(Sort) + 1 END) FROM Ecshop_BaseUnits;INSERT INTO dbo.Ecshop_BaseUnits( HSJoinID, Name_CN,Sort,CreateUser,CreateTime )VALUES(@HSJoinID,@Name_CN,@DisplaySequence,@CreateUser,getdate()); SELECT @@IDENTITY");
this.database.AddInParameter(sqlStringCommand, "HSJoinID", DbType.String, model.HSJoinID);
this.database.AddInParameter(sqlStringCommand, "Name_CN", DbType.String, model.Name_CN);
this.database.AddInParameter(sqlStringCommand, "CreateUser", DbType.String, model.CreateUser);
object obj = this.database.ExecuteScalar(sqlStringCommand);
if (obj != null)
{
if (Convert.ToInt32(obj) > 0)
{
return(true);
}
}
return(false);
}
/// <summary>
/// 验证数据格式
/// </summary>
/// <param name="baseUnits"></param>
/// <returns></returns>
private bool ValidationUnit(BaseUnitsInfo baseUnits)
{
ValidationResults validationResults = Validation.Validate <BaseUnitsInfo>(baseUnits, new string[]
{
"ValBaseUnits"
});
string text = string.Empty;
if (!validationResults.IsValid)
{
foreach (ValidationResult current in (System.Collections.Generic.IEnumerable <ValidationResult>)validationResults)
{
text += Formatter.FormatErrorMessage(current.Message);
}
this.ShowMsg(text, false);
}
return(validationResults.IsValid);
}
/// <summary>
/// 添加计量单位
/// </summary>
/// <param name="type">1：添加一个后跳转到列表页；2：连续添加</param>
private void AddBaseUnit(int type)
{
ManagerHelper.CheckPrivilege(Privilege.UnitsAdd);
BaseUnitsInfo baseUnitsInfo = this.GetBaseUnitsInfo();
if (baseUnitsInfo == null || !this.ValidationUnit(baseUnitsInfo))
{
return;
}
var member = HiContext.Current.User;
if (member == null || member.IsLockedOut)
{
return;
}
baseUnitsInfo.CreateUser = member.Username + "_" + member.UserId;
if (CatalogHelper.IsExistUnit(baseUnitsInfo.HSJoinID, baseUnitsInfo.Name_CN, 0))
{
this.ShowMsg("海关代码或计量单位名称已存在，请重新填写", true);
return;
}
if (CatalogHelper.AddUnit(baseUnitsInfo))
{
if (type == 1)
{
base.Response.Redirect(Globals.GetAdminAbsolutePath("/product/BaseUnits.aspx"), true);
}
else
{
this.ShowMsg("成功添加计量单位", true);
}
return;
}
this.ShowMsg("添加计量单位失败", true);
return;
}
/// <summary>
/// 获取页面传递计量单位数据
/// </summary>
/// <returns></returns>
private BaseUnitsInfo GetBaseUnitsInfo()
{
string HSJoinID = Globals.HtmlEncode(Globals.StripHtmlXmlTags(Globals.StripScriptTags(this.txtHSJoinID.Text.Trim())).Replace("\\", ""));
if (string.IsNullOrEmpty(HSJoinID))
{
this.ShowMsg("请填写海关代码,海关代码中不能包含HTML字符，脚本字符，以及\\", false);
return(null);
}
string Name_CN = Globals.HtmlEncode(Globals.StripHtmlXmlTags(Globals.StripScriptTags(this.txtUnitName.Text.Trim())).Replace("\\", ""));
if (string.IsNullOrEmpty(Name_CN))
{
this.ShowMsg("请填写计量单位名称,计量单位名称中不能包含HTML字符，脚本字符，以及\\", false);
return(null);
}
BaseUnitsInfo baseUnitsInfo = new BaseUnitsInfo();
baseUnitsInfo.HSJoinID = HSJoinID;
baseUnitsInfo.Name_CN = Name_CN;
return(baseUnitsInfo);
}
/// <summary>
/// 编辑计量单位
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool EditUnit(BaseUnitsInfo model)
{
return(new BaseUnitDao().EditUnit(model));
}
/////////////////////////////计量单位/////////////////////////////////////////////////
/// <summary>
/// 新增计量单位
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool AddUnit(BaseUnitsInfo model)
{
return(new BaseUnitDao().AddUnit(model));
}
