protected void btnDelete_ServerClick(Object sender, EventArgs e)
{
//string familyId = this.dFamily.Text.Trim();
string oldId = this.dOldId.Value.Trim();
try
{
QCRatioDef item = new QCRatioDef();
item.Family = oldId;
iQCRatio.DeleteQCRatio(item);
}
catch (FisException ex)
{
showErrorMessage(ex.mErrmsg);
return;
}
catch (Exception ex)
{
//show error
showErrorMessage(ex.Message);
return;
}
ShowListByCustom();
this.updatePanel2.Update();
ScriptManager.RegisterStartupScript(this.updatePanelAll, typeof(System.Object), "saveUpdate", "DeleteComplete();DealHideWait();", true);
}
//若Family为空，则将当前Customer保存到记录中的Family栏位
//GetExistQCRatio(String customer, string QCRatioId)
//SELECT [IMES_FA].[dbo].[QCRatio].[Family]
// FROM [IMES_FA].[dbo].[QCRatio] inner join
//[IMES_GetData].[dbo].[Family] on [IMES_FA].[dbo].[QCRatio].[Family]=[IMES_GetData].[dbo].[Family].[Family]
//WHERE [IMES_GetData].[dbo].[Family].[CustomerID]='customer'
//AND [IMES_FA].[dbo].[QCRatio].[Family]='QCRatioId'
//change to:
// SELECT [IMES_FA_Datamaintain].[dbo].[QCRatio].[Family]
// FROM [IMES_FA_Datamaintain].[dbo].[QCRatio] inner join
// (select [IMES_GetData_Datamaintain].[dbo].[Family].Family from [IMES_GetData_Datamaintain].[dbo].[Family]
// WHERE [IMES_GetData_Datamaintain].[dbo].[Family].[CustomerID]='customer' union
// select [IMES_GetData_Datamaintain].dbo.Customer.Customer AS [Family] from [IMES_GetData_Datamaintain].dbo.Customer
// WHERE [IMES_GetData_Datamaintain].dbo.Customer.Customer='customer'
// ) AS C
//on [IMES_FA_Datamaintain].[dbo].[QCRatio].[Family]=C.[Family]
// WHERE [IMES_FA_Datamaintain].[dbo].[QCRatio].[Family]='QCRatioId'
//change to:
//SELECT [Family]
// FROM [QCRatio]
//WHERE [QCRatio].[Family]=@ QCRatioFamily
public string AddQCRatio(QCRatioDef item)
{
String result = "";
try
{
IFamilyRepository itemRepository = RepositoryFactory.GetInstance().GetRepository<IFamilyRepository>();
DataTable exists=itemRepository.GetExistQCRatio(item.Family);
if (exists != null && exists.Rows.Count > 0)
{
//已经存在具有相同Customer和Family的QCRatio记录
List<string> erpara = new List<string>();
FisException ex;
ex = new FisException("DMT007", erpara);
throw ex;
}
int intQCRatio;
int intEOQCRatio;
int intPAQCRatio;
int intRPAQCRatio;
if (item.QCRatio == "")
{
intQCRatio = Int32.MinValue;
}
else
{
intQCRatio = Int32.Parse(item.QCRatio);
}
if (item.EOQCRatio == "")
{
intEOQCRatio = Int32.MinValue;
}
else
{
intEOQCRatio = Int32.Parse(item.EOQCRatio);
}
if (item.PAQCRatio == "")
{
intPAQCRatio = Int32.MinValue;
}
else
{
intPAQCRatio = Int32.Parse(item.PAQCRatio);
}
if (item.RPAQCRatio == "")
{
intRPAQCRatio = Int32.MinValue;
}
else
{
intRPAQCRatio = Int32.Parse(item.RPAQCRatio);
}
QCRatio itemQCRatio=new QCRatio(
item.Family,
intQCRatio,
intEOQCRatio,
intPAQCRatio,
item.Editor,
DateTime.Now,
DateTime.Now,
intRPAQCRatio
);
itemRepository.AddQCRatio(itemQCRatio);
result = itemQCRatio.Family;
}
catch (Exception)
{
throw;
}
return result;
}
protected void btnAdd_ServerClick(Object sender, EventArgs e)
{
QCRatioDef item = new QCRatioDef();
String itemId;
String model = this.cmbMaintainModelByFamily.InnerDropDownList.SelectedValue;
if (model != "")
{
item.Family = model;
}
else
{
item.Family = this.cmbMaintainFamily.InnerDropDownList.SelectedValue;
}
item.QCRatio = this.dQCRatio.Text.Trim();
item.EOQCRatio = this.dEQQCRatio.Text.Trim();
item.PAQCRatio = this.dPAQCRatio.Text.Trim();
item.RPAQCRatio = this.dRPAQCRatio.Text.Trim();
item.Customer = this.cmbCustomer.InnerDropDownList.SelectedValue;
item.Editor = this.HiddenUserName.Value;
try
{
itemId=iQCRatio.AddQCRatio(item);
}
catch (FisException ex)
{
showErrorMessage(ex.mErrmsg);
return;
}
catch (Exception ex)
{
//show error
showErrorMessage(ex.Message);
return;
}
ShowListByCustom();
itemId = replaceSpecialChart(itemId);
this.updatePanel2.Update();
ScriptManager.RegisterStartupScript(this.updatePanelAll, typeof(System.Object), "saveUpdate", "AddUpdateComplete('" + itemId + "');DealHideWait();", true);
}
public void DeleteQCRatio(QCRatioDef item)
{
try
{
IFamilyRepository itemRepository = RepositoryFactory.GetInstance().GetRepository<IFamilyRepository>();
QCRatio itemQCRatio = new QCRatio(
item.Family,
0,
0,
0,
"",
DateTime.Now,
DateTime.Now,
0);
itemRepository.DeleteQCRatio(itemQCRatio);
}
catch (Exception)
{
throw;
}
}