protected void TempRadGrid_UpdateCommand(object sender, GridCommandEventArgs e)
{
var editedItem = e.Item as GridEditableItem;
if (editedItem != null)
{
var tempId = new Guid(editedItem.GetDataKeyValue("TempId").ToString());
string templateName = ((TextBox)editedItem.FindControl("TB_TemplateName")).Text;
string shipper = ((TextBox)editedItem.FindControl("TB_Shipper")).Text;
string contactPerson = ((TextBox)editedItem.FindControl("TB_ContactPerson")).Text;
string contactAddress = ((TextBox)editedItem.FindControl("TB_ContactAddress")).Text;
string remarks = ((TextBox)editedItem.FindControl("TB_Remarks")).Text;
string customer = ((TextBox)editedItem.FindControl("TB_Customer")).Text;
var tempInfo = new ExcelTemplateInfo
{
TempId = tempId,
TemplateName = templateName,
Shipper = shipper,
ContactPerson = contactPerson,
ContactAddress = contactAddress,
Customer = customer,
Remarks = remarks,
WarehouseId = new Guid(RCB_Stock.SelectedValue)
};
try
{
_temp.Update(tempInfo);
}
catch (Exception ex)
{
RAM.Alert("修改失败!可能修改的模板名存在相同的!" + ex.Message);
}
}
}
protected void TempRadGrid_InsertCommand(object sender, GridCommandEventArgs e)
{
var editedItem = e.Item as GridEditableItem;
if (editedItem != null)
{
string templateName = ((TextBox)editedItem.FindControl("TB_TemplateName")).Text;
string shipper = ((TextBox)editedItem.FindControl("TB_Shipper")).Text;
string contactPerson = ((TextBox)editedItem.FindControl("TB_ContactPerson")).Text;
string contactAddress = ((TextBox)editedItem.FindControl("TB_ContactAddress")).Text;
string remarks = ((TextBox)editedItem.FindControl("TB_Remarks")).Text;
string customer = ((TextBox)editedItem.FindControl("TB_Customer")).Text;
var tempInfo = new ExcelTemplateInfo
{
TemplateName = templateName,
Shipper = shipper,
ContactPerson = contactPerson,
ContactAddress = contactAddress,
Customer = customer,
Remarks = remarks
};
try
{
_temp.Insert(tempInfo);
}
catch (Exception ex)
{
RAM.Alert("添加失败 可能已经含有相同的模板名!" + ex.Message);
}
}
}
/// <summary>
/// 功 能:插入Excel模板
/// 时 间:2010-11-18
/// 作 者:蒋赛标
/// </summary>
/// <param name="tInfo">Excel模板实体</param>
public int Insert(ExcelTemplateInfo tInfo)
{
const string SQL_EXCEL_TEMPATE_INSERT = @"Insert into lmshop_ExcelTemplate (TempId,Customer,TemplateName,Shipper,ContactPerson,ContactAddress,Remarks,WarehouseId)
Values(@TempId,@Customer,@TemplateName,@Shipper,@ContactPerson,@ContactAddress,@Remarks,@WarehouseId)";
using (SqlConnection conn = Databases.GetSqlConnection(GlobalConfig.ERP_DB_NAME, false))
{
return(conn.Execute(SQL_EXCEL_TEMPATE_INSERT, new
{
TempId = Guid.NewGuid(),
Customer = tInfo.Customer,
TemplateName = tInfo.TemplateName,
Shipper = tInfo.Shipper,
ContactPerson = tInfo.ContactPerson,
ContactAddress = tInfo.ContactAddress,
Remarks = tInfo.Remarks,
WarehouseId = tInfo.WarehouseId,
}));
}
}
/// <summary>
/// 功 能:修改Excel模板信息
/// 时 间:2010-11-18
/// 作 者:蒋赛标
/// </summary>
/// <param name="tInfo">Excel模板实体</param>
public int Update(ExcelTemplateInfo tInfo)
{
const string SQL_EXCEL_TEMPLATE_UPDATE = @"Update lmshop_ExcelTemplate Set Customer=@Customer, TemplateName=@TemplateName,Shipper=@Shipper,
ContactPerson=@ContactPerson,ContactAddress=@ContactAddress,Remarks=@Remarks ,WarehouseId=@WarehouseId
Where TempId=@TempId ";
using (SqlConnection conn = Databases.GetSqlConnection(GlobalConfig.ERP_DB_NAME, false))
{
return(conn.Execute(SQL_EXCEL_TEMPLATE_UPDATE, new
{
TempId = Guid.NewGuid(),
Customer = tInfo.Customer,
TemplateName = tInfo.TemplateName,
Shipper = tInfo.Shipper,
ContactPerson = tInfo.ContactPerson,
ContactAddress = tInfo.ContactAddress,
Remarks = tInfo.Remarks,
WarehouseId = tInfo.WarehouseId,
}));
}
}
