/// <summary>
///添加记录
/// </summary>
/// <param name="InvtoType"></param>
/// <returns></returns>
public int GetInsert(M_InvtoType model)
{
//return dal.GetInsert(invtoType);
string sqlStr = "INSERT INTO [dbo].[ZL_InvtoType] ([InvtoType],[Invto],[Addtime],[AdminID],[Remark]) VALUES (@InvtoType,@Invto,@Addtime,@AdminID,@Remark);select @@IDENTITY";
SqlParameter[] cmdParams = model.GetParameters();
return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, sqlStr, cmdParams)));
}
/// <summary>
///更新记录
/// </summary>
/// <param name="InvtoType"></param>
/// <returns></returns>
public bool GetUpdate(M_InvtoType model)
{
//return dal.GetUpdate(invtoType);
string sqlStr = "UPDATE [dbo].[ZL_InvtoType] SET [InvtoType] = @InvtoType,[Invto] = @Invto,[Addtime] = @Addtime,[AdminID] = @AdminID,[Remark]=@Remark WHERE [ID] = @ID";
SqlParameter[] cmdParams = model.GetParameters();
return(SqlHelper.ExecuteSql(sqlStr, cmdParams));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int ids = DataConverter.CLng(Request.QueryString["id"]);
if (ids > 0)
{
M_InvtoType minvtype = bll.GetSelect(ids);
this.invType.Text = "修改发票类型";
string[] inv = minvtype.InvtoType.Split('[');
deliname.Text = inv[0];
deliinfo.Text = minvtype.Remark;
shuilv.Text = minvtype.Invto.ToString();
ID_H.Value = ids.ToString();
}
else
{
this.invType.Text = "添加发票类型";
}
Call.SetBreadCrumb(Master, "<li><a href='" + CustomerPageAction.customPath2 + "I/Main.aspx'>工作台</a></li><li><a href='ProductManage.aspx'>商城管理</a></li> <li><a href='DeliverType.aspx'>商城设置</a></li><li><a href='InvtoManage.aspx'>发票类型管理</a></li><li>添加发票类型</li>");
}
}
//保存
protected void Button1_Click(object sender, EventArgs e)
{
int ids = DataConverter.CLng(ID_H.Value);
M_InvtoType minvtype = new M_InvtoType();
minvtype.ID = ids;
minvtype.InvtoType = deliname.Text + "[" + shuilv.Text + "%税率]";
minvtype.Remark = deliinfo.Text;
minvtype.Invto = DataConverter.CFloat(shuilv.Text);
minvtype.Addtime = DateTime.Now;
minvtype.AdminID = badmin.GetAdminLogin().AdminId;
if (ids > 0)
{
bool result = bll.GetUpdate(minvtype);
if (result)
{
function.WriteSuccessMsg("修改成功", "InvtoManage.aspx");
}
else
{
function.WriteErrMsg("修改失败");
}
}
else
{
int mid = bll.GetInsert(minvtype);
if (mid > 0)
{
function.WriteSuccessMsg("添加成功", "InvtoManage.aspx");
}
else
{
function.WriteErrMsg("添加失败");
}
}
}
public int insert(M_InvtoType model)
{
return(Sql.insert(strTableName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
/// <summary>
/// 根据ID更新
/// </summary>
public bool UpdateByID(M_InvtoType model)
{
return(Sql.UpdateByIDs(strTableName, PK, model.ID.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters()));
}
