///<summary>
///删除数据
/// </summary>
/// <param name="pObj">信息集实体类</param>
/// <returns>返回保存成功(true)或失败(false)</returns>
public void InsertData(List <StockYJ> lstStockYJ)
{
CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql);
try
{
pComm.BeginTrans();
//先删除
for (int i = 0; i < lstStockYJ.Count; i++)
{
string strDeleteSql = "Delete from StockYJ where MaterialGuid='" + lstStockYJ[i].MaterialGuid + "'";
pComm.Execute(strDeleteSql);
}
//后插入
for (int i = 0; i < lstStockYJ.Count; i++)
{
pComm.Execute(GetInsertSQL(lstStockYJ[i]));
}
pComm.CommitTrans();
}
catch (Exception e)
{
pComm.RollbackTrans();
pComm.Close();
throw e;
}
}
///<summary>
///删除数据
/// </summary>
/// <param name="pObj">信息集实体类</param>
/// <returns>返回保存成功(true)或失败(false)</returns>
public void DeleteBill(string FileApplyguid)
{
CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql);
try
{
pComm.BeginTrans();
//保存单据主表数据
//先删除主表数据
string strDeleteSql = "Delete from FileApply where FileApplyGuid='" + FileApplyguid + "'";
pComm.Execute(strDeleteSql);
//删除明细表
strDeleteSql = "Delete from FileApplyDetail where FileApplyGuid='" + FileApplyguid + "'";
pComm.Execute(strDeleteSql);
//删除申请人明细表
strDeleteSql = "Delete from FileApplyPersonDetail where FileApplyGuid='" + FileApplyguid + "'";
pComm.Execute(strDeleteSql);
pComm.CommitTrans();
}
catch (Exception e)
{
pComm.RollbackTrans();
pComm.Close();
throw e;
}
}
///<summary>
///删除数据
/// </summary>
/// <param name="pObj">信息集实体类</param>
/// <returns>返回保存成功(true)或失败(false)</returns>
public void DeleteBill(string IncomeOrderGuid)
{
CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql);
try
{
pComm.BeginTrans();
//保存单据主表数据
//先删除主表数据
string strDeleteSql = "Delete from IncomeOrder where IncomeOrderGuid='" + IncomeOrderGuid + "'";
pComm.Execute(strDeleteSql);
//删除明细表1
strDeleteSql = "Delete from IncomeOrderDetail1 where IncomeOrderGuid='" + IncomeOrderGuid + "'";
pComm.Execute(strDeleteSql);
//删除明细表2
strDeleteSql = "Delete from IncomeOrderDetail2 where IncomeOrderGuid='" + IncomeOrderGuid + "'";
pComm.Execute(strDeleteSql);
pComm.CommitTrans();
}
catch (Exception e)
{
pComm.RollbackTrans();
pComm.Close();
throw e;
}
}
///<summary>
///删除数据
/// </summary>
/// <param name="pObj">信息集实体类</param>
/// <returns>返回保存成功(true)或失败(false)</returns>
public void DeleteBill(string materialMRPPlanGuid)
{
CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql);
try
{
pComm.BeginTrans();
//保存单据主表数据
//先删除主表数据
string strDeleteSql = "Delete from MaterialMRPPlan where MaterialMRPPlanGuid='" + materialMRPPlanGuid + "'";
pComm.Execute(strDeleteSql);
//删除明细表
strDeleteSql = "Delete from MaterialMRPPlanDetail where MaterialMRPPlanGuid='" + materialMRPPlanGuid + "'";
pComm.Execute(strDeleteSql);
//删除明细表
strDeleteSql = "Delete from MaterialMRPPlanCalcSum where MaterialMRPPlanGuid='" + materialMRPPlanGuid + "'";
pComm.Execute(strDeleteSql);
pComm.CommitTrans();
}
catch (Exception e)
{
pComm.RollbackTrans();
pComm.Close();
throw e;
}
}
///<summary>
/// 删除数据
/// </summary>
/// <param name="pObj">信息集实体类</param>
/// <returns>返回保存成功(true)或失败(false)</returns>
public void DetailMaterialBom(string strMaterialFatherGuid)
{
CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql);
try
{
pComm.BeginTrans();
//删除集合中的bom子件数据
string strDeleteSql = "";
strDeleteSql = "Delete from MaterialBomDetail where MaterialFatherGuid='" + strMaterialFatherGuid + "'";
pComm.Execute(strDeleteSql);
//删除集合中的bom母件数据
strDeleteSql = "";
strDeleteSql = "Delete from MaterialBom where MaterialGuid='" + strMaterialFatherGuid + "' ";
pComm.Execute(strDeleteSql);
pComm.CommitTrans();
}
catch (Exception e)
{
pComm.RollbackTrans();
pComm.Close();
throw e;
}
}
///<summary>
/// 保存用户属于那个权限组
/// </summary>
/// <param name="tableid">SQL查询条件</param>
/// <returns>存放查询结果的DataTable</returns>
public void SaveUserRightGroup(List <string> lstUser, List <string> lstgroup)
{
string StrSQL = "";
CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql);
try
{
pComm.BeginTrans();
for (int i = 0; i < lstUser.Count; i++)
{
//先删除此用户原来属于的权限组
StrSQL = "delete from UserRightGroup where UserID='" + lstUser[i] + "'";
pComm.Execute(StrSQL);
//再添加此用户的权限组
for (int j = 0; j < lstgroup.Count; j++)
{
StrSQL = " insert into UserRightGroup(UserID,GroupID) values('" + lstUser[i] + "','" + lstgroup [j] + "')";
pComm.Execute(StrSQL);
}
}
pComm.CommitTrans();
pComm.Close();
}
catch (Exception e)
{
pComm.RollbackTrans();
pComm.Close();
throw e;
}
}
///<summary>
///删除数据
/// </summary>
/// <param name="pObj">信息集实体类</param>
/// <returns>返回保存成功(true)或失败(false)</returns>
public void DeleteFileData(string FileGuID)
{
CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql);
try
{
pComm.BeginTrans();
//保存单据主表数据
//先删除主表数据
string strDeleteSql = "Delete from FileData where FileGuID='" + FileGuID + "'";
pComm.Execute(strDeleteSql);
//删除明细附件表
strDeleteSql = "Delete from FileDataAttachment where FileGuID='" + FileGuID + "'";
pComm.Execute(strDeleteSql);
pComm.CommitTrans();
}
catch (Exception e)
{
pComm.RollbackTrans();
pComm.Close();
throw e;
}
}
/// <summary>
/// 删除文件
/// </summary>
/// <param name="FileTypeID"></param>
/// <returns></returns>
public void DeleteFile(string FileGuID)
{
string ps_Sql = "";
DataTable pDTMain = new DataTable();
CommonInterface pObj_Comm = CommonFactory.CreateInstance(CommonData.sql);
pObj_Comm.BeginTrans();
try
{
ps_Sql = " delete from FileData where FileGuID='" + FileGuID + "'";
pObj_Comm.Execute(ps_Sql);
ps_Sql = " delete from FileDataAttachment where FileGuID='" + FileGuID + "'";
pObj_Comm.Execute(ps_Sql);
pObj_Comm.CommitTrans();
pObj_Comm.Close();
}
catch (Exception e)
{
pObj_Comm.RollbackTrans();
pObj_Comm.Close();
throw e;
}
}
///<summary>
///删除数据
/// </summary>
/// <param name="pObj">信息集实体类</param>
/// <returns>返回保存成功(true)或失败(false)</returns>
public void DeleteBill(string HalfGoodsguid)
{
CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql);
try
{
pComm.BeginTrans();
//保存单据主表数据
//先删除主表数据
string strDeleteSql = "Delete from HalfGoods where HalfGoodsGuid='" + HalfGoodsguid + "'";
pComm.Execute(strDeleteSql);
//删除明细表
strDeleteSql = "Delete from HalfGoodsDetail where HalfGoodsGuid='" + HalfGoodsguid + "'";
pComm.Execute(strDeleteSql);
pComm.CommitTrans();
}
catch (Exception e)
{
pComm.RollbackTrans();
pComm.Close();
throw e;
}
}
/// <summary>
/// 删除
/// </summary>
/// <returns></returns>
public void DeleteCheckBill(string CheckBillGuid)
{
CommonInterface pObj_Comm = CommonFactory.CreateInstance(CommonData.sql);
try
{
pObj_Comm.BeginTrans();
//删除主表
string ps_Sql = "delete from CheckBill where CheckBillGuid='" + CheckBillGuid + "'";
pObj_Comm.Execute(ps_Sql);
//删除明细表
ps_Sql = "delete from CheckBillDetail where CheckBillGuid='" + CheckBillGuid + "'";
pObj_Comm.Execute(ps_Sql);
pObj_Comm.CommitTrans();
pObj_Comm.Close();
}
catch (Exception e)
{
pObj_Comm.RollbackTrans();
pObj_Comm.Close();
throw e;
}
}
///<summary>
/// 保存数据
/// </summary>
/// <param name="pObj">信息集实体类</param>
/// <returns>返回保存成功(true)或失败(false)</returns>
public void SaveBill(FileApply FileApply, List <FileApplyDetail> FileApplyDetail, List <FileApplyPersonDetail> lstFileApplyPersonDetail)
{
CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql);
try
{
pComm.BeginTrans();
//保存单据主表数据
//先删除主表数据
string strDeleteSql = "Delete from FileApply where FileApplyGuid='" + FileApply.FileApplyGuID + "'";
pComm.Execute(strDeleteSql);
//插入主表数据
string strInsertSql = GetAddBillSQL(FileApply);
pComm.Execute(strInsertSql);
//删除明细表
strDeleteSql = "Delete from FileApplyDetail where FileApplyGuid='" + FileApply.FileApplyGuID + "'";
pComm.Execute(strDeleteSql);
//插入明细表数据
for (int i = 0; i < FileApplyDetail.Count; i++)
{
strInsertSql = GetAddBillDetailSQL(FileApplyDetail[i]);
pComm.Execute(strInsertSql);
}
//删除申请人员明细
strDeleteSql = "Delete from FileApplyPersonDetail where FileApplyGuid='" + FileApply.FileApplyGuID + "'";
pComm.Execute(strDeleteSql);
//插入申请人员明细
for (int i = 0; i < lstFileApplyPersonDetail.Count; i++)
{
strInsertSql = GetAddBillPersonDetailSQL(lstFileApplyPersonDetail[i]);
pComm.Execute(strInsertSql);
}
pComm.CommitTrans();
}
catch (Exception e)
{
pComm.RollbackTrans();
pComm.Close();
throw e;
}
}
///<summary>
/// 保存数据----点击保存时用
/// </summary>
/// <param name="pObj">信息集实体类</param>
/// <returns>返回保存成功(true)或失败(false)</returns>
public void SaveBill(DrawPlan DrawPlan, List <DrawPlanDetail> DrawPlanDetail, List <DrawPlanCalcSumDetail> DrawPlanCalcSumDetail)
{
CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql);
try
{
pComm.BeginTrans();
//保存单据主表数据
//先删除主表数据
string strDeleteSql = "Delete from DrawPlan where DrawPlanGuid='" + DrawPlan.DrawPlanGuid + "'";
pComm.Execute(strDeleteSql);
//插入主表数据
string strInsertSql = GetAddSQL(DrawPlan);
pComm.Execute(strInsertSql);
//删除明细表
strDeleteSql = "Delete from DrawPlanDetail where DrawPlanGuid='" + DrawPlan.DrawPlanGuid + "'";
pComm.Execute(strDeleteSql);
//插入明细表数据
for (int i = 0; i < DrawPlanDetail.Count; i++)
{
strInsertSql = GetAddDetailSQL(DrawPlanDetail[i]);
pComm.Execute(strInsertSql);
}
//删除计算明细
strDeleteSql = "Delete from DrawPlanCalcSum where DrawPlanGuid='" + DrawPlan.DrawPlanGuid + "'";
pComm.Execute(strDeleteSql);
//插入明细表数据
for (int i = 0; i < DrawPlanCalcSumDetail.Count; i++)
{
strInsertSql = GetAddCalcSumSQL(DrawPlanCalcSumDetail[i]);
pComm.Execute(strInsertSql);
}
pComm.CommitTrans();
}
catch (Exception e)
{
pComm.RollbackTrans();
pComm.Close();
throw e;
}
}
///<summary>
/// 保存数据----点击保存时用
/// </summary>
/// <param name="pObj">信息集实体类</param>
/// <returns>返回保存成功(true)或失败(false)</returns>
public void SaveBill(IncomeOrder IncomeOrder, List <IncomeOrderDetail1> IncomeOrderDetail1, List <IncomeOrderDetail2> IncomeOrderDetail2)
{
CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql);
try
{
pComm.BeginTrans();
//保存单据主表数据
//先删除主表数据
string strDeleteSql = "Delete from IncomeOrder where IncomeOrderGuid='" + IncomeOrder.IncomeOrderGuid + "'";
pComm.Execute(strDeleteSql);
//插入主表数据
string strInsertSql = GetAddSQL(IncomeOrder);
pComm.Execute(strInsertSql);
//删除明细表
strDeleteSql = "Delete from IncomeOrderDetail1 where IncomeOrderGuid='" + IncomeOrder.IncomeOrderGuid + "'";
pComm.Execute(strDeleteSql);
//插入明细表数据
for (int i = 0; i < IncomeOrderDetail1.Count; i++)
{
strInsertSql = GetAddDetailSQL1(IncomeOrderDetail1[i]);
pComm.Execute(strInsertSql);
}
//删除计算明细
strDeleteSql = "Delete from IncomeOrderDetail2 where IncomeOrderGuid='" + IncomeOrder.IncomeOrderGuid + "'";
pComm.Execute(strDeleteSql);
//插入明细表数据
for (int i = 0; i < IncomeOrderDetail2.Count; i++)
{
strInsertSql = GetAddDetailSQL2(IncomeOrderDetail2[i]);
pComm.Execute(strInsertSql);
}
pComm.CommitTrans();
}
catch (Exception e)
{
pComm.RollbackTrans();
pComm.Close();
throw e;
}
}
///<summary>
///删除数据
/// </summary>
/// <param name="pObj">信息集实体类</param>
/// <returns>返回保存成功(true)或失败(false)</returns>
public void DeleteBill(string Equipmentguid)
{
CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql);
try
{
pComm.BeginTrans();
//保存单据主表数据
//先删除主表数据
string strDeleteSql = "Delete from Equipment where EquipmentGuid='" + Equipmentguid + "'";
pComm.Execute(strDeleteSql);
//删除明细表
strDeleteSql = "Delete from EquipmentDie where EquipmentGuid='" + Equipmentguid + "'";
pComm.Execute(strDeleteSql);
//删除明细表
strDeleteSql = "Delete from EquipmentFrock where EquipmentGuid='" + Equipmentguid + "'";
pComm.Execute(strDeleteSql);
//删除明细表
strDeleteSql = "Delete from EquipmentGage where EquipmentGuid='" + Equipmentguid + "'";
pComm.Execute(strDeleteSql);
//删除明细表
strDeleteSql = "Delete from EquipmentInformation where EquipmentGuid='" + Equipmentguid + "'";
pComm.Execute(strDeleteSql);
//删除明细表
strDeleteSql = "Delete from EquipmentOffice where EquipmentGuid='" + Equipmentguid + "'";
pComm.Execute(strDeleteSql);
pComm.CommitTrans();
}
catch (Exception e)
{
pComm.RollbackTrans();
pComm.Close();
throw e;
}
}
///<summary>
/// 保存数据
/// </summary>
/// <param name="pObj">信息集实体类</param>
/// <returns>返回保存成功(true)或失败(false)</returns>
public void SaveMaterialBom(MaterialBom materialbom, List <MaterialBomDetail> materialbomdetail)
{
CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql);
try
{
pComm.BeginTrans();
//删除集合中的bom子件数据
string strDeleteSql = "";
strDeleteSql = "Delete from MaterialBomDetail where MaterialFatherGuid='" + materialbom.MaterialGuid + "'";
pComm.Execute(strDeleteSql);
//删除集合中的bom母件数据
strDeleteSql = "";
strDeleteSql = "Delete from MaterialBom where MaterialGuid='" + materialbom.MaterialGuid + "' ";
pComm.Execute(strDeleteSql);
//插入母件数据
string strInsertSql = "";
strInsertSql = GetAddSQL(materialbom);
pComm.Execute(strInsertSql);
//插入子件数据
strInsertSql = "";
for (int i = 0; i < materialbomdetail.Count; i++)
{
strInsertSql = GetAddDetailSQL(materialbomdetail[i]);
pComm.Execute(strInsertSql);
}
pComm.CommitTrans();
}
catch (Exception e)
{
pComm.RollbackTrans();
pComm.Close();
throw e;
}
}
///<summary>
/// 保存数据
/// </summary>
/// <param name="pObj">信息集实体类</param>
/// <returns>返回保存成功(true)或失败(false)</returns>
public void SaveCheckBill(CheckBill CheckBill, List <CheckBillDetail> CheckBillDetail)
{
CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql);
try
{
pComm.BeginTrans();
//保存单据主表数据
//先删除主表数据
string strDeleteSql = "Delete from CheckBill where CheckBillGuid='" + CheckBill.CheckBillGuid + "'";
pComm.Execute(strDeleteSql);
//插入主表数据
string strInsertSql = GetAddCheckBillSQL(CheckBill);
pComm.Execute(strInsertSql);
//删除明细表
strDeleteSql = "Delete from CheckBillDetail where CheckBillGuid='" + CheckBill.CheckBillGuid + "'";
pComm.Execute(strDeleteSql);
//插入明细表数据
for (int i = 0; i < CheckBillDetail.Count; i++)
{
strInsertSql = GetAddCheckBillDetailSQL(CheckBillDetail[i]);
pComm.Execute(strInsertSql);
}
pComm.CommitTrans();
}
catch (Exception e)
{
pComm.RollbackTrans();
pComm.Close();
throw e;
}
}
///<summary>
/// 保存数据
/// </summary>
/// <param name="pObj">信息集实体类</param>
/// <returns>返回保存成功(true)或失败(false)</returns>
public void SaveBill(RejectOrder RejectOrder, List <RejectOrderDetail> RejectOrderDetail)
{
CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql);
try
{
pComm.BeginTrans();
//保存单据主表数据
//先删除主表数据
string strDeleteSql = "Delete from RejectOrder where RejectOrderGuid='" + RejectOrder.RejectOrderGuid + "'";
pComm.Execute(strDeleteSql);
//插入主表数据
string strInsertSql = GetAddBillSQL(RejectOrder);
pComm.Execute(strInsertSql);
//删除明细表
strDeleteSql = "Delete from RejectOrderDetail where RejectOrderGuid='" + RejectOrder.RejectOrderGuid + "'";
pComm.Execute(strDeleteSql);
//插入明细表数据
for (int i = 0; i < RejectOrderDetail.Count; i++)
{
strInsertSql = GetAddBillDetailSQL(RejectOrderDetail[i]);
pComm.Execute(strInsertSql);
}
pComm.CommitTrans();
}
catch (Exception e)
{
pComm.RollbackTrans();
pComm.Close();
throw e;
}
}
///<summary>
/// 保存数据
/// </summary>
/// <param name="pObj">信息集实体类</param>
/// <returns>返回保存成功(true)或失败(false)</returns>
public void SaveBill(InitialGoods InitialGoods, List <InitialGoodsDetail> InitialGoodsDetail)
{
CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql);
try
{
pComm.BeginTrans();
//保存单据主表数据
//先删除主表数据
string strDeleteSql = "Delete from InitialGoods where InitialGoodsGuid='" + InitialGoods.InitialGoodsGuid + "'";
pComm.Execute(strDeleteSql);
//插入主表数据
string strInsertSql = GetAddBillSQL(InitialGoods);
pComm.Execute(strInsertSql);
//删除明细表
strDeleteSql = "Delete from InitialGoodsDetail where InitialGoodsGuid='" + InitialGoods.InitialGoodsGuid + "'";
pComm.Execute(strDeleteSql);
//插入明细表数据
for (int i = 0; i < InitialGoodsDetail.Count; i++)
{
strInsertSql = GetAddBillDetailSQL(InitialGoodsDetail[i]);
pComm.Execute(strInsertSql);
}
pComm.CommitTrans();
}
catch (Exception e)
{
pComm.RollbackTrans();
pComm.Close();
throw e;
}
}
///<summary>
/// 保存数据
/// </summary>
/// <param name="pObj">信息集实体类</param>
/// <returns>返回保存成功(true)或失败(false)</returns>
public void SaveChangeBill(ChangeBill ChangeBill, List <ChangeBillDataAttachment> ChangeBillDataAttachment)
{
CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql);
try
{
pComm.BeginTrans();
//保存单据主表数据
//先删除主表数据
string strDeleteSql = "Delete from ChangeBill where ChangeBillGuID='" + ChangeBill.ChangeBillGuID + "'";
pComm.Execute(strDeleteSql);
//插入主表数据
string strInsertSql = GetAddSQL(ChangeBill);
pComm.Execute(strInsertSql);
//删除明细表
strDeleteSql = "Delete from ChangeBillDataAttachment where ChangeBillGuID='" + ChangeBill.ChangeBillGuID + "'";
pComm.Execute(strDeleteSql);
//插入明细表数据
for (int i = 0; i < ChangeBillDataAttachment.Count; i++)
{
AddChangeBillDataAttachment(ChangeBillDataAttachment[i], pComm);
}
pComm.CommitTrans();
}
catch (Exception e)
{
pComm.RollbackTrans();
pComm.Close();
throw e;
}
}
///<summary>
/// 保存组的功能模块权限
/// </summary>
/// <param name="tableid">SQL查询条件</param>
/// <returns>存放查询结果的DataTable</returns>
public void SaveGroupFunctionRight(List <string> lstGroup, List <GroupRightSet> lstFunctionRight)
{
string StrSQL = "";
GroupRightSet GroupRightSet = new GroupRightSet();
CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql);
try
{
pComm.BeginTrans();
for (int i = 0; i < lstGroup.Count; i++)
{
//先删除此组原来属于的功能权限
StrSQL = "delete from GroupRightSet where GroupID='" + lstGroup[i] + "'";
pComm.Execute(StrSQL);
//再添加此组属于的功能权限
for (int j = 0; j < lstFunctionRight.Count; j++)
{
GroupRightSet = lstFunctionRight[j] as GroupRightSet;
StrSQL = " insert into GroupRightSet(GroupID,ModuleID,FunctionID,FunctionRight) values('"
+ lstGroup[i] + "','" + GroupRightSet.ModuleID + "','" + GroupRightSet.FunctionID + "'," + GroupRightSet.FunctionRight.ToString() + ")";
pComm.Execute(StrSQL);
}
}
pComm.CommitTrans();
pComm.Close();
}
catch (Exception e)
{
pComm.RollbackTrans();
pComm.Close();
throw e;
}
}
///<summary>
/// 输入条件返回结果查询
/// </summary>
/// <param name="tableid">SQL查询条件</param>
/// <returns>存放查询结果的DataTable</returns>
public void DeleteSyslog(List <string> lst)
{
CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql);
try
{
pComm.BeginTrans();
string StrSQL = "";
for (int i = 0; i < lst.Count; i++)
{
StrSQL = " delete from SystemLog where NoID='" + lst[i] + "'";
pComm.Execute(StrSQL);
}
pComm.CommitTrans();
pComm.Close();
}
catch (Exception e)
{
pComm.RollbackTrans();
pComm.Close();
throw e;
}
}
///<summary>
/// 保存数据
/// </summary>
/// <param name="pObj">信息集实体类</param>
/// <returns>返回保存成功(true)或失败(false)</returns>
public void SaveFile(FileData FileData, List <FileDataAttachment> FileDataAttachment)
{
CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql);
try
{
pComm.BeginTrans();
//保存单据主表数据
//先删除主表数据
string strDeleteSql = "Delete from FileData where FileGuID='" + FileData.FileGuID + "'";
pComm.Execute(strDeleteSql);
//插入主表数据
string strInsertSql = GetAddSQL(FileData);
pComm.Execute(strInsertSql);
//删除明细表
strDeleteSql = "Delete from FileDataAttachment where FileGuID='" + FileData.FileGuID + "'";
pComm.Execute(strDeleteSql);
//插入明细表数据
for (int i = 0; i < FileDataAttachment.Count; i++)
{
AddFileDataAttachment(FileDataAttachment[i], pComm);
}
/*先查找与当前文件相同文件编号的文件,再以发布日期来判断，如果当前文件比系统中存在的文件发布日期新，
* 则把发布日期旧的自动停用，另外所有用到这个旧文件的地方全部以这个新文件替换*/
string strSQL = " select FileID from FileData where FileID='" + FileData.FileID + "' and PublishDate>'" + FileData.PublishDate.ToString() + "'";
DataTable dtl = pComm.ExeForDtl(strSQL);
if (dtl.Rows.Count <= 0)
{
//执行将相同文件编号并且发布日期为旧的文件全部禁用,并且以新的这个文件替代旧的文件
strSQL = " update FileData set IsEnable=1 where FileID='" + FileData.FileID + "' and PublishDate<'" + FileData.PublishDate.ToString() + "'";
pComm.Execute(strSQL);
//将所有用到这些禁用文件的地方全部替换为新的文件
strSQL = " Update FileInStorageDetail set FileGuID='" + FileData.FileGuID
+ "' where FileGuID in (select FileGuID from FileData where FileID='" + FileData.FileID
+ "' and PublishDate<'" + FileData.PublishDate.ToString() + "')";
pComm.Execute(strSQL);
strSQL = " Update FileApplyDetail set FileGuID='" + FileData.FileGuID
+ "' where FileGuID in (select FileGuID from FileData where FileID='" + FileData.FileID
+ "' and PublishDate<'" + FileData.PublishDate.ToString() + "')";
pComm.Execute(strSQL);
}
pComm.CommitTrans();
}
catch (Exception e)
{
pComm.RollbackTrans();
pComm.Close();
throw e;
}
}
///<summary>
/// 保存数据
/// </summary>
/// <param name="pObj">信息集实体类</param>
/// <returns>返回保存成功(true)或失败(false)</returns>
public void SaveBill(Equipment Equipment, EquipmentDie EquipmentDie, EquipmentFrock EquipmentFrock, EquipmentGage EquipmentGage, EquipmentOffice EquipmentOffice, EquipmentInformation EquipmentInformation)
{
CommonInterface pComm = CommonFactory.CreateInstance(CommonData.sql);
try
{
pComm.BeginTrans();
//保存单据主表数据
//先删除主表数据
string strDeleteSql = "Delete from Equipment where EquipmentGuid='" + Equipment.EquipmentGuID + "'";
pComm.Execute(strDeleteSql);
//插入Equipment数据
string strInsertSql = GetEquipment_AddSQL(Equipment);
pComm.Execute(strInsertSql);
switch (Equipment.EquipmentType)
{
case "1":
//删除EquipmentDie表
strDeleteSql = "Delete from EquipmentDie where EquipmentGuid='" + Equipment.EquipmentGuID + "'";
pComm.Execute(strDeleteSql);
//插入EquipmentDie数据
strInsertSql = GetEquipmentDie_AddSQL(EquipmentDie);
pComm.Execute(strInsertSql);
break;
case "2":
//删除EquipmentGage表
strDeleteSql = "Delete from EquipmentGage where EquipmentGuid='" + Equipment.EquipmentGuID + "'";
pComm.Execute(strDeleteSql);
//插入EquipmentGage数据
strInsertSql = GetEquipmentGage_AddSQL(EquipmentGage);
pComm.Execute(strInsertSql);
break;
case "3":
//删除EquipmentInformation表
strDeleteSql = "Delete from EquipmentInformation where EquipmentGuid='" + Equipment.EquipmentGuID + "'";
pComm.Execute(strDeleteSql);
//插入EquipmentInformation数据
strInsertSql = GetEquipmentInformation_AddSQL(EquipmentInformation);
pComm.Execute(strInsertSql);
break;
case "4":
//删除EquipmentOffice表
strDeleteSql = "Delete from EquipmentOffice where EquipmentGuid='" + Equipment.EquipmentGuID + "'";
pComm.Execute(strDeleteSql);
//插入EquipmentOffice数据
strInsertSql = GetEquipmentOffice_AddSQL(EquipmentOffice);
pComm.Execute(strInsertSql);
break;
case "5":
//删除EquipmentFrock表
strDeleteSql = "Delete from EquipmentFrock where EquipmentGuid='" + Equipment.EquipmentGuID + "'";
pComm.Execute(strDeleteSql);
//插入EquipmentFrock数据
strInsertSql = GetEquipmentFrock_AddSQL(EquipmentFrock);
pComm.Execute(strInsertSql);
break;
}
pComm.CommitTrans();
}
catch (Exception e)
{
pComm.RollbackTrans();
pComm.Close();
throw e;
}
}
/// <summary>
/// 更新审核状态度,同时要执行业务
/// 1.先找到当前文件编号+版本的记录，复制一条出来，只是将新版本号去更新这条记录
/// 2.同时将当前工程更改单中的附件数据也更新到刚才复制出来的记录中，将原来老的记录删除掉
/// 3.同时将所有申请单中引用旧的编号+版本号的记录全部替换成新的复制出来的那条记录guid
/// </summary>
/// <returns></returns>
public void CheckBill(string ChangeBillGuID, int pass, string FileGuID, string NewVersionID)
{
CommonInterface pObj_Comm = CommonFactory.CreateInstance(CommonData.sql);
pObj_Comm.BeginTrans();
try
{
string ps_Sql = "";
//删除主表
if (pass == 1)
{
//更新审批状态
ps_Sql = "update ChangeBill set CheckGuid='" + SysParams.UserID + "',CheckDate='" + DateTime.Now.ToString() + "' where ChangeBillGuID='" + ChangeBillGuID + "'";
pObj_Comm.Execute(ps_Sql);
//根据文件编号+版本复制一条数据出来,GuID换成新的
string GuID = Guid.NewGuid().ToString();
ps_Sql = "insert into FileData(FileGuID,FileID,FileName,FileType,ProductName,PublishDate,VersionID,WriteDept,ControlType,IsEnable,Remark,CreateGuid,CreateDate)"
+ " select '" + GuID + "',FileID,FileName,FileType,ProductName,PublishDate,'" + NewVersionID + "',WriteDept,ControlType,IsEnable,'工程更改单创建 '+Remark,CreateGuid,CreateDate "
+ " from FileData where FileGuID='" + FileGuID + "'";
pObj_Comm.Execute(ps_Sql);
//插入明细
ps_Sql = "insert into FileDataAttachment(FileDataAttachmentGuid,FileGuID,FileSourceName,FileContent) "
+ " select newid(),'" + GuID + "',FileSourceName,FileContent "
+ " from ChangeBillDataAttachment where ChangeBillGuID='" + ChangeBillGuID + "'";
pObj_Comm.Execute(ps_Sql);
//将申请单表所有用到文件编号+旧版本的文件Guid全部替换为新的文件编号+新版本号的文件guid
ps_Sql = "update FileApplyDetail set FileGuID='" + GuID + "' where FileGuID='" + FileGuID + "'";
pObj_Comm.Execute(ps_Sql);
//将入库记录也要换成新的guid
ps_Sql = "update FileInStorageDetail set FileGuID='" + GuID + "' where FileGuID='" + FileGuID + "'";
pObj_Comm.Execute(ps_Sql);
}
else
{
//不通过
ps_Sql = "update ChangeBill set CheckGuid='',CheckDate=null where ChangeBillGuID='" + ChangeBillGuID + "'";
pObj_Comm.Execute(ps_Sql);
}
pObj_Comm.CommitTrans();
pObj_Comm.Close();
}
catch (Exception e)
{
pObj_Comm.RollbackTrans();
pObj_Comm.Close();
throw e;
}
}
