public static int UpdateApprovalToolOrder(string MainTableName, string OrderIDs, int ApprovalStatus, string Description)
{
string sSqlText = "begin";
sSqlText += " Insert Into ApprovalLog_Info (MainTableName, MainID, ApprovalStatus, ApprovalUserID, ApprovalTime, Description) "
+ " (Select '" + MainTableName + "', ID, " + ApprovalStatus.ToString() + "," + SysGlobal.GetCurrentUserID().ToString()
+ ", GetDate(), '" + Description + "' From ToolOrder_Info Where Status=0 And ID In (" + OrderIDs + ")); ";
sSqlText += " Update ToolOrder_Info Set ApprovalStatus=" + ApprovalStatus.ToString()
+ ", ApprovalUserID=" + SysGlobal.GetCurrentUserID().ToString() + ", ApprovalTime=GetDate() "
+ " Where Status=0 And ID In (" + OrderIDs + ");";
if (ApprovalStatus == DepotTool_ApprovalIsOK)
{
sSqlText += "Update PurchaseCredit_Info Set UsedTotalCredit=UsedTotalCredit+b.TotalAmount"
+ ",UsedCredit1=IsNull(UsedCredit1,0)+(Case Month(b.OrderDate) when 1 then b.TotalAmount else 0 end)"
+ ",UsedCredit2=IsNull(UsedCredit2,0)+(Case Month(b.OrderDate) when 2 then b.TotalAmount else 0 end)"
+ ",UsedCredit3=IsNull(UsedCredit3,0)+(Case Month(b.OrderDate) when 3 then b.TotalAmount else 0 end)"
+ ",UsedCredit4=IsNull(UsedCredit4,0)+(Case Month(b.OrderDate) when 4 then b.TotalAmount else 0 end)"
+ ",UsedCredit5=IsNull(UsedCredit5,0)+(Case Month(b.OrderDate) when 5 then b.TotalAmount else 0 end)"
+ ",UsedCredit6=IsNull(UsedCredit6,0)+(Case Month(b.OrderDate) when 6 then b.TotalAmount else 0 end)"
+ ",UsedCredit7=IsNull(UsedCredit7,0)+(Case Month(b.OrderDate) when 7 then b.TotalAmount else 0 end)"
+ ",UsedCredit8=IsNull(UsedCredit8,0)+(Case Month(b.OrderDate) when 8 then b.TotalAmount else 0 end)"
+ ",UsedCredit9=IsNull(UsedCredit9,0)+(Case Month(b.OrderDate) when 9 then b.TotalAmount else 0 end)"
+ ",UsedCredit10=IsNull(UsedCredit10,0)+(Case Month(b.OrderDate) when 10 then b.TotalAmount else 0 end)"
+ ",UsedCredit11=IsNull(UsedCredit11,0)+(Case Month(b.OrderDate) when 11 then b.TotalAmount else 0 end)"
+ ",UsedCredit12=IsNull(UsedCredit12,0)+(Case Month(b.OrderDate) when 12 then b.TotalAmount else 0 end)"
+ " From ToolOrder_Info b Where b.Status=0 And OrderType=0 And b.ID In (" + OrderIDs + ")"
+ " And PurchaseCredit_Info.OrganID=b.OrganID And PurchaseCredit_Info.PurchaseYear=Year(b.OrderDate);";
}
sSqlText += " end;";
return(DataCommon.QueryData(sSqlText));
}
//更新用户密码
public static Boolean CheckUserNoExists(int _ID, string OpCode)
{
string sSqlText = "Select 1 From SysUser_Info Where OpCode='" + OpCode + "' "//And IsNull(SystemID,0)=" + SysParams.GetPurviewSystemID().ToString()
+ " And ID<>" + _ID.ToString();
return(SysGlobal.GetExecSqlIsExist(sSqlText));
}
public static Boolean CheckToolISNoExists(int ToolISID, string ToolISNo)
{
string sSqlText = "Select 1 From ToolIS_Info Where "
+ " ToolISNo='" + ToolISNo + "' And ID<>" + ToolISID.ToString();
return(SysGlobal.GetExecSqlIsExist(sSqlText));
}
//更新用户密码
public static Boolean CheckUserPassword(int UserID, string Password)
{
string sSqlText = "Select 1 From SysUser_Info Where "//IsNull(SystemID,0)=" + SysParams.GetPurviewSystemID().ToString()
+ " Password='******' And ID=" + UserID;
return(SysGlobal.GetExecSqlIsExist(sSqlText));
}
public static Boolean CheckToolOutNoExists(int ToolOutID, string ToolOutNo)
{
string sSqlText = "Select 1 From ToolOut_Info Where ToolOutType=" + ToolOutType_ToolOutValue.ToString()
+ " And ToolOutNo='" + ToolOutNo + "' And ID<>" + ToolOutID.ToString();
return(SysGlobal.GetExecSqlIsExist(sSqlText));
}
//---新增、修改订单
public static int UpNewOrder(int _ID, string[] FieldValues, string DetailsSQL)
{
string Sql = "";
if (_ID > 0)
{
Sql = Sql + " UPDATE InterPhoneOrder_Info SET OrderNo='" + FieldValues.GetValue(1)
+ "',Description='" + FieldValues.GetValue(3) + "'"
+ ",Isfinish=" + FieldValues.GetValue(4);
Sql = Sql + " WHERE ID=" + _ID + "" + ";";
Sql += " ;";
}
else
{
Sql = Sql + " Insert Into InterPhoneOrder_Info (TableRecGuid"
+ ", OrderNo"
+ ", OrderDate"
+ ", OrganID"
+ ", OrderUserID"
+ ", Description"
+ ", Isfinish)"
+ " Values('" + FieldValues.GetValue(0) + "'"
+ ",'" + FieldValues.GetValue(1) + "'"
+ ",GetDate()"
+ "," + SysGlobal.GetCurrentUserOrganID().ToString()
+ ",'" + SysGlobal.GetCurrentUserID().ToString() + "'"
+ ",'" + FieldValues.GetValue(3) + "'"
+ "," + FieldValues.GetValue(4) + ")";
Sql = Sql + " ;";
}
Sql = Sql + DetailsSQL;
return(DataCommon.QueryData(Sql));
}
//判断机构编号是否重复
public static Boolean CheckOrganNoExists(int OrganID, string OrganNo)
{
string sSqlText = "Select 1 From SysOrgan_Info Where OrganNo='" + OrganNo //+ "' And IsNull(SystemID,0)=" + SysParams.GetPurviewSystemID().ToString()
+ "' And ID<>" + OrganID.ToString();
return(SysGlobal.GetExecSqlIsExist(sSqlText));
}
//判断预案编号已被使用
public static bool CheckRoleIsUse(int RoleID)
{
string sSqlText = "Select top 1 1 From User_Info Where Status=0 "//And IsNull(SystemID,0)=" + SysParams.GetPurviewSystemID().ToString()
+ " And ','+UserRoles+',' Like '%," + RoleID.ToString() + ",%'";
return(SysGlobal.GetExecSqlIsExist(sSqlText));
}
public static Boolean CheckBackTestNoExists(int BackTestID, string BackTestNo)
{
string sSqlText = "Select 1 From BackTest_Info "
+ " Where BackTestNo='" + BackTestNo + "' And ID<>" + BackTestID.ToString();
return(SysGlobal.GetExecSqlIsExist(sSqlText));
}
public static int AddUploadFiles(int MasterTableType, string MasterTableRecGuid, string sSubCategory, string UploadFileName, string FileName, string FileExt, string FileSize, string sDetailSQL)
{
string sUpdateSQL = " Begin";
sUpdateSQL += " INSERT INTO SysUploadFile_Info (MasterTableType"
+ ", MasterTableRecGuid"
+ ",SubCategory"
+ ",UploadFileName"
+ ",FileName"
+ ",FileExt"
+ ",FileSize"
+ ",UserID) "
+ "VALUES(" + MasterTableType.ToString() + ""
+ ",'" + MasterTableRecGuid + "'"
+ ",'" + sSubCategory + "'"
+ ",'" + UploadFileName + "'"
+ ",'" + FileName + "'"
+ ",'" + FileExt + "'"
+ "," + FileSize
+ "," + SysGlobal.GetCurrentUserID().ToString()
+ ");";
sUpdateSQL += sDetailSQL + " End;";
return(DataCommon.QueryData(sUpdateSQL));
}
public static Boolean CheckSendServiceNoExists(int SendServiceID, string SendServiceNo)
{
string sSqlText = "Select 1 From SendService_Info "
+ " Where SendServiceNo='" + SendServiceNo + "' And ID<>" + SendServiceID.ToString();
return(SysGlobal.GetExecSqlIsExist(sSqlText));
}
public static Boolean CheckInventoryNoExists(int InventoryID, string InventoryNo)
{
string sSqlText = "Select 1 From Inventory_Info "
+ " Where InventoryNo='" + InventoryNo + "' And ID<>" + InventoryID.ToString();
return(SysGlobal.GetExecSqlIsExist(sSqlText));
}
public static Boolean CheckBorrowNoExists(int ConsumeID, string ConsumeNo)
{
string sSqlText = "Select 1 From Consume_Info Where ConsumeType=" + ConsumeType_BorrowValue.ToString()
+ " And ConsumeNo='" + ConsumeNo + "' And ID<>" + ConsumeID.ToString();
return(SysGlobal.GetExecSqlIsExist(sSqlText));
}
public static Boolean CheckConsumeNoExists(int ConsumeID, string ConsumeNo)
{
string sSqlText = "Select 1 From InterPhoneInspection_Info Where ConsumeType=" + ConsumeType_ConsumeValue.ToString()
+ " And ConsumeNo='" + ConsumeNo + "' And ID<>" + ConsumeID.ToString();
return(SysGlobal.GetExecSqlIsExist(sSqlText));
}
public static Boolean CheckUserSalaryNoExists(int UserSalaryID, string UserSalaryNo)
{
string sSqlText = "Select 1 From UserSalary_Info Where UserSalaryType=" + UserSalaryType_UserSalaryValue.ToString()
+ " And UserSalaryNo='" + UserSalaryNo + "' And ID<>" + UserSalaryID.ToString();
return(SysGlobal.GetExecSqlIsExist(sSqlText));
}
//获取角色是否重复
public static bool CheckRoleNameExists(int ID, string RoleName)
{
string sSqlText = "select 1 from SysRole_Info where "//IsNull(SystemID,0)=" + SysParams.GetPurviewSystemID().ToString()
+ " RoleName ='" + RoleName.ToString() + "' and ID<>" + ID.ToString();
return(SysGlobal.GetExecSqlIsExist(sSqlText));
}
//更新添加工具档案信息
public static int UpdateSingleSendOut(int _ID, string[] FieldValues, string DetailsSQL)
{
string sSqlText = "begin";
sSqlText += " Update ToolStock_Info Set ToolStock_Info.Quantity=ToolStock_Info.Quantity + b.Quantity "
+ ", ToolStock_Info.SendOutQuantity=ToolStock_Info.SendOutQuantity - b.Quantity"
+ " From (Select ToolID, Sum(Quantity) As Quantity From SendOutDetails_Info a, SendOut_Info b where a.SendOutID=b.Id "
+ " And b.TableRecGuid='" + FieldValues.GetValue(0) + "' and b.ApprovalStatus=1 And b.Status=0 Group By ToolID) b "
+ " Where ToolStock_Info.ToolID=b.ToolID And ToolStock_Info.OrganID=" + SysGlobal.GetCurrentUserOrganID().ToString() + ";";
if (_ID > 0)
{
sSqlText = sSqlText + " UPDATE SendOut_Info SET SendOutNo='" + FieldValues.GetValue(1) + "'"
+ ",Description='" + FieldValues.GetValue(3) + "'"
+ ",ApprovalStatus='" + FieldValues.GetValue(4) + "'";
sSqlText = sSqlText + " WHERE ID=" + _ID + "" + ";";
sSqlText += " ;";
}
else
{
sSqlText = sSqlText + " Insert Into SendOut_Info (TableRecGuid"
+ ", SendOutNo"
+ ", SendOutDate"
+ ", SendOutOrganID"
+ ", AcceptOrganID"
+ ", SendOutUserID"
+ ", Description"
+ ", ApprovalStatus)"
+ " Values('" + FieldValues.GetValue(0) + "'"
+ ",'" + FieldValues.GetValue(1) + "'"
+ ",GetDate()"
+ "," + SysGlobal.GetCurrentUserOrganID().ToString()
+ "," + FieldValues.GetValue(2)
+ ",'" + SysGlobal.GetCurrentUserID().ToString() + "'"
+ ",'" + FieldValues.GetValue(3) + "'"
+ ",'" + FieldValues.GetValue(4) + "')";
sSqlText += " ;";
}
sSqlText = sSqlText + DetailsSQL;
sSqlText += " Insert Into ToolStock_Info (OrganID, ToolID, Quantity)"
+ " (Select distinct " + SysClass.SysGlobal.GetCurrentUserOrganID().ToString() + ", ToolID, 0 From SendOutDetails_Info Where Status=0 "
+ " And SendOutID In (Select ID From SendOut_Info Where Status=0 And IsNull(ApprovalStatus,0)=1 And TableRecGuid='" + FieldValues.GetValue(0) + "')"
+ " And ToolID not in (Select ToolID From ToolStock_Info Where OrganID=" + SysClass.SysGlobal.GetCurrentUserOrganID().ToString() + "));";
sSqlText += " Update ToolStock_Info Set ToolStock_Info.Quantity=ToolStock_Info.Quantity - b.Quantity "
+ ", ToolStock_Info.SendOutQuantity=ToolStock_Info.SendOutQuantity + b.Quantity"
+ " From (Select ToolID, Sum(Quantity) As Quantity From SendOutDetails_Info a, SendOut_Info b where a.SendOutID=b.Id "
+ " And b.TableRecGuid='" + FieldValues.GetValue(0) + "'and b.ApprovalStatus=1 And b.Status=0 Group By ToolID) b "
+ " Where ToolStock_Info.ToolID=b.ToolID And ToolStock_Info.OrganID=" + SysGlobal.GetCurrentUserOrganID().ToString() + ";";
sSqlText += " Update ToolStockDetail_Info Set ToolStockDetail_Info.ToolStatus=7 From "
+ " SendOutDetails_Info b where b.SendOutID In (Select ID From SendOut_Info Where Status=0 And IsNull(ApprovalStatus,0)=1 And TableRecGuid='" + FieldValues.GetValue(0) + "') and ToolStockDetail_Info.ID=b.ToolDetailID"
+ " And ToolStockDetail_Info.OrganID=" + SysClass.SysGlobal.GetCurrentUserOrganID() + ";";
sSqlText += " end;";
return(DataCommon.QueryData(sSqlText));
}
//判断机构编号已被使用
public static bool CheckToolsNoticeIsUse(int NoticeID)
{
string sSqlText = "Select top 1 1 From User_Info Where Status=0 And NoticeID=" + NoticeID.ToString()
+ " union all "
+ " Select top 1 1 From Notice_Info Where Status=0 And PNoticeID=" + NoticeID.ToString();
return(SysGlobal.GetExecSqlIsExist(sSqlText));
}
//判断机构编号已被使用
public static bool CheckToolsCategoryIsUse(int CategoryID)
{
string sSqlText = "Select top 1 1 From User_Info Where Status=0 And CategoryID=" + CategoryID.ToString()
+ " union all "
+ " Select top 1 1 From ToolCategory_Info Where Status=0 And PCategoryID=" + CategoryID.ToString();
return(SysGlobal.GetExecSqlIsExist(sSqlText));
}
//判断机构编号已被使用
public static bool CheckOrganIsUse(int OrganID)
{
string sSqlText = "Select top 1 1 From User_Info Where Status=0 "//And IsNull(SystemID,0)=" + SysParams.GetPurviewSystemID().ToString()
+ " And OrganID=" + OrganID.ToString()
+ " union all "
+ " Select top 1 1 From SysOrgan_Info Where Status=0"// And IsNull(SystemID,0)=" + SysParams.GetPurviewSystemID().ToString()
+ " And POrganID=" + OrganID.ToString();
return(SysGlobal.GetExecSqlIsExist(sSqlText));
}
//更新添加工具档案信息
public static int UpdateSingleRepairFee(int _ID, string[] FieldValues)
{
string sSqlText = " begin";
sSqlText += " Update PurchaseCredit_Info Set UsedTotalCredit=UsedTotalCredit-b.RepairAmount"
+ ",UsedCredit1=IsNull(UsedCredit1,0)+(Case Month(b.RepairDate) when 1 then b.RepairAmount else 0 end)"
+ ",UsedCredit2=IsNull(UsedCredit2,0)+(Case Month(b.RepairDate) when 2 then b.RepairAmount else 0 end)"
+ ",UsedCredit3=IsNull(UsedCredit3,0)+(Case Month(b.RepairDate) when 3 then b.RepairAmount else 0 end)"
+ ",UsedCredit4=IsNull(UsedCredit4,0)+(Case Month(b.RepairDate) when 4 then b.RepairAmount else 0 end)"
+ ",UsedCredit5=IsNull(UsedCredit5,0)+(Case Month(b.RepairDate) when 5 then b.RepairAmount else 0 end)"
+ ",UsedCredit6=IsNull(UsedCredit6,0)+(Case Month(b.RepairDate) when 6 then b.RepairAmount else 0 end)"
+ ",UsedCredit7=IsNull(UsedCredit7,0)+(Case Month(b.RepairDate) when 7 then b.RepairAmount else 0 end)"
+ ",UsedCredit8=IsNull(UsedCredit8,0)+(Case Month(b.RepairDate) when 8 then b.RepairAmount else 0 end)"
+ ",UsedCredit9=IsNull(UsedCredit9,0)+(Case Month(b.RepairDate) when 9 then b.RepairAmount else 0 end)"
+ ",UsedCredit10=IsNull(UsedCredit10,0)+(Case Month(b.RepairDate) when 10 then b.RepairAmount else 0 end)"
+ ",UsedCredit11=IsNull(UsedCredit11,0)+(Case Month(b.RepairDate) when 11 then b.RepairAmount else 0 end)"
+ ",UsedCredit12=IsNull(UsedCredit12,0)+(Case Month(b.RepairDate) when 12 then b.RepairAmount else 0 end)"
+ " From RepairFee_Info b Where b.Status=0 And b.ID = " + _ID.ToString()
+ " And PurchaseCredit_Info.OrganID=b.OrganID And PurchaseCredit_Info.PurchaseYear=Year(b.RepairDate);";
if (_ID > 0)
{
sSqlText += " UPDATE RepairFee_Info SET OrganID=" + FieldValues.GetValue(0)
+ ", RepairDate='" + FieldValues.GetValue(1) + "'"
+ ",RepairAmount=" + FieldValues.GetValue(2)
+ ",Description='" + FieldValues.GetValue(3) + "'";
sSqlText += sSqlText + " WHERE ID=" + _ID + "" + ";";
}
else
{
sSqlText += " Insert Into RepairFee_Info ( OrganID, RepairDate, RepairAmount, CreateUserID, Description) Values("
+ FieldValues.GetValue(0) + ",'" + FieldValues.GetValue(1) + "',"
+ FieldValues.GetValue(2) + "," + SysGlobal.GetCurrentUserID().ToString() + ",'"
+ FieldValues.GetValue(3) + "')" + ";";
}
sSqlText += " Update PurchaseCredit_Info Set UsedTotalCredit=UsedTotalCredit+b.RepairAmount"
+ ",UsedCredit1=IsNull(UsedCredit1,0)+(Case Month(b.RepairDate) when 1 then b.RepairAmount else 0 end)"
+ ",UsedCredit2=IsNull(UsedCredit2,0)+(Case Month(b.RepairDate) when 2 then b.RepairAmount else 0 end)"
+ ",UsedCredit3=IsNull(UsedCredit3,0)+(Case Month(b.RepairDate) when 3 then b.RepairAmount else 0 end)"
+ ",UsedCredit4=IsNull(UsedCredit4,0)+(Case Month(b.RepairDate) when 4 then b.RepairAmount else 0 end)"
+ ",UsedCredit5=IsNull(UsedCredit5,0)+(Case Month(b.RepairDate) when 5 then b.RepairAmount else 0 end)"
+ ",UsedCredit6=IsNull(UsedCredit6,0)+(Case Month(b.RepairDate) when 6 then b.RepairAmount else 0 end)"
+ ",UsedCredit7=IsNull(UsedCredit7,0)+(Case Month(b.RepairDate) when 7 then b.RepairAmount else 0 end)"
+ ",UsedCredit8=IsNull(UsedCredit8,0)+(Case Month(b.RepairDate) when 8 then b.RepairAmount else 0 end)"
+ ",UsedCredit9=IsNull(UsedCredit9,0)+(Case Month(b.RepairDate) when 9 then b.RepairAmount else 0 end)"
+ ",UsedCredit10=IsNull(UsedCredit10,0)+(Case Month(b.RepairDate) when 10 then b.RepairAmount else 0 end)"
+ ",UsedCredit11=IsNull(UsedCredit11,0)+(Case Month(b.RepairDate) when 11 then b.RepairAmount else 0 end)"
+ ",UsedCredit12=IsNull(UsedCredit12,0)+(Case Month(b.RepairDate) when 12 then b.RepairAmount else 0 end)"
+ " From RepairFee_Info b Where b.Status=0 And b.ID = " + _ID.ToString()
+ " And PurchaseCredit_Info.OrganID=b.OrganID And PurchaseCredit_Info.PurchaseYear=Year(b.RepairDate);";
sSqlText += " end;";
return(DataCommon.QueryData(sSqlText));
}
//系统登录
public static bool UserLogin(string sOpCode, string sPassword, System.Web.SessionState.HttpSessionState hsSession)
{
bool bSuccess = false;
SqlDataReader sda = GetUserLogin(sOpCode, sPassword);
if (sda.Read())
{
UserInfo info = new UserInfo();
info.UserID = int.Parse(sda["ID"].ToString());
info.OpGuid = sda["Guid"].ToString();
info.OpCode = sda["OpCode"].ToString();
info.OpName = sda["OpName"].ToString();
//权限移到选择系统界面
//info.UserRolePurview = GetPurviewByUserID(info.UserID);
info.Purview = info.UserRolePurview;
info.UserRoles = sda["UserRoles"].ToString();
info.IsAdmin = sda["IsAdmin"].ToString() == "1";
if (sda["LastDate"].ToString().Length > 0)
{
info.LastDate = DateTime.Parse(sda["LastDate"].ToString()).ToString("yyyy年MM月dd日 HH:mm:ss");
}
//info.PurviewSystemID = 0;
info.LastIp = sda["LastIP"].ToString();
info.LastComputerName = sda["LastComputerName"].ToString();
if (sda["OrganID"].ToString().Length > 0)
{
info.OrganID = SysClass.SysOrgan.GetWorkShopByOrganID(int.Parse(sda["OrganID"].ToString()));
}
else
{
info.OrganID = SysClass.SysOrgan.GetTopOrganID(0);
}
CyxPack.UserCommonOperation.UserCommonOperation.StoreUserInfo(info);
// string IP = HttpContext.Current.Request.UserHostAddress;//获取客户端电脑IP
string IP = "";
System.Net.IPAddress[] addressList = Dns.GetHostByName(Dns.GetHostName()).AddressList;
IP = addressList[0].ToString();
string ComputerName;
ComputerName = System.Net.Dns.GetHostName(); //获取本地计算机的主机名
SysLogs.CreateUserLogin(info.UserID, info.OpCode, info.OpName, "用户登录系统。", IP, ComputerName);
SysClass.SysGlobal.CurrentUserOrganID = SysGlobal.GetCurrentUserOrganID();
bSuccess = true;
}
sda.Close();
return(bSuccess);
}
//审批保存
public static int UpdateApprovalToolOrder(string MainTableName, string OrderIDs, int ApprovalStatus, string Description)
{
string sSqlText = "begin";
sSqlText += " Insert Into ApprovalLog_Info (MainTableName, MainID, ApprovalStatus, ApprovalUserID, ApprovalTime, Description) "
+ " (Select '" + MainTableName + "', ID, " + ApprovalStatus.ToString() + "," + SysGlobal.GetCurrentUserID().ToString()
+ ", GetDate(), '" + Description + "' From WorksShopInterOrder_Info Where Status=0 And ID In (" + OrderIDs + ")); ";
sSqlText += " Update WorksShopInterOrder_Info Set Isfinish=" + ApprovalStatus.ToString()
+ ", ApprovalUserID=" + SysGlobal.GetCurrentUserID().ToString() + ", ApprovalTime=GetDate() "
+ " Where Status=0 And ID In (" + OrderIDs + ");";
sSqlText += " end;";
return(DataCommon.QueryData(sSqlText));
}
public static int UpdateToolTestInfo(int ToolDetailID, int TestUserID, string TestCode, int TestStatus, string Description)
{
string sSqlText = "begin";
sSqlText += " Insert Into ToolTest_Info (ToolDetailID, TestCode, TestDate, TestStatus, Description, TestUserID, OrganID, CreateUserID) "
+ " Values(" + ToolDetailID.ToString() + ", '" + TestCode.ToString() + "', GetDate()," + TestStatus.ToString()
+ ",'" + Description + "' ," + TestUserID.ToString() + "," + SysGlobal.GetCurrentUserOrganID().ToString()
+ "," + SysGlobal.GetCurrentUserID().ToString()
+ "); ";
sSqlText += " Update ToolStockDetail_Info Set TestCode='" + TestCode + "', TestStatus=" + TestStatus.ToString() + ", TestDate=GetDate() Where ID=" + ToolDetailID.ToString() + ";";
sSqlText += " end;";
return(DataCommon.QueryData(sSqlText));
}
public static SqlDataReader GetWhereServiceStockDetailToolLstByReader(int CategoryID, string WhereSQL)
{
string sSQL = "Select c.*, a.ID as ToolDetailID, a.ToolCode, a.TestCode, IsNull(b.ServiceQuantity, 0) As StockQuantity, 0 As OldQuantity, b.StorageLocation from ToolStockDetail_Info a "
+ " left join ToolStock_Info b on b.Status=0 And a.ToolID=b.ToolID And b.OrganID=" + SysGlobal.GetCurrentUserOrganID().ToString()
+ " left join Tool_Info c on c.Status=0 And a.ToolID=c.ID "
+ " Where c.ToolType=" + _NomalToolType.ToString()
+ " And a.OrganID=" + SysGlobal.GetCurrentUserOrganID().ToString() + " And a.Status=0" + WhereSQL;
if (CategoryID > 0)
{
sSQL = sSQL + " And c.CategoryID=" + CategoryID.ToString();
}
sSQL = sSQL + " Order By a.SortID";
return(DataCommon.GetDataByReader(sSQL));
}
//更新添加工具档案信息
public static int UpdateSingleToolOrder(int _ID, string[] FieldValues, string DetailsSQL)
{
string sSqlText = "begin";
if (_ID > 0)
{
sSqlText = sSqlText + " UPDATE ToolOrder_Info SET OrderNo='" + FieldValues.GetValue(1)
+ "',OrderType=" + FieldValues.GetValue(2)
+ ",Description='" + FieldValues.GetValue(3) + "'"
+ ",ApprovalStatus='" + FieldValues.GetValue(4) + "'"
+ ",TotalAmount=" + FieldValues.GetValue(5);
sSqlText = sSqlText + " WHERE ID=" + _ID + "" + ";";
sSqlText += " ;";
}
else
{
//sSqlText += " if not exists(Select OrganID, PurchaseYear From PurchaseCredit_Info Where OrganID=" + SysGlobal.GetCurrentUserOrganID().ToString()
// + " And PurchaseYear=year(getdate()))"
// + " begin"
// + " Insert Into PurchaseCredit_Info (OrganID, PurchaseYear) Values (" + SysGlobal.GetCurrentUserOrganID().ToString() + ", year(getdate()));"
// + " end;";
sSqlText = sSqlText + " Insert Into ToolOrder_Info (TableRecGuid"
+ ", OrderNo"
+ ", OrderDate"
+ ", OrderType"
+ ", OrganID"
+ ", OrderUserID"
+ ", Description"
+ ", ApprovalStatus"
+ ", TotalAmount)"
+ " Values('" + FieldValues.GetValue(0) + "'"
+ ",'" + FieldValues.GetValue(1) + "'"
+ ",GetDate()"
+ "," + FieldValues.GetValue(2)
+ "," + SysGlobal.GetCurrentUserOrganID().ToString()
+ ",'" + SysGlobal.GetCurrentUserID().ToString() + "'"
+ ",'" + FieldValues.GetValue(3) + "'"
+ ",'" + FieldValues.GetValue(4) + "'"
+ "," + FieldValues.GetValue(5) + ")";
sSqlText = sSqlText + " ;";
}
sSqlText = sSqlText + DetailsSQL
+ " end;";
return(DataCommon.QueryData(sSqlText));
}
//添加修改检验单
public static int UpUserInspection(int _ID, string[] FieldValues, string Sql)
{
string sSqlText = "";
if (_ID > 0)
{
sSqlText = sSqlText + " UPDATE InterPhoneCarry_Info SET ConsumeNo='" + FieldValues.GetValue(1) + "'"
+ ",ConsumeUserID=" + FieldValues.GetValue(2) + ""
+ ",Description='" + FieldValues.GetValue(3) + "'"
+ ",ServiceID='" + FieldValues.GetValue(5) + "'"
+ ",ApprovalStatus='" + FieldValues.GetValue(4) + "'";
sSqlText = sSqlText + " WHERE ID=" + _ID + "" + ";";
sSqlText = sSqlText + Sql + " ;";
}
else
{
sSqlText = sSqlText + " Insert Into InterPhoneCarry_Info (TableRecGuid"
+ ", ConsumeNo"
+ ", ConsumeType"
+ ", ConsumeDate"
+ ", OrganID"
+ ", ConsumeUserID"
+ ", CreateUserID"
+ ", ServiceID"
+ ", Description"
+ ", ApprovalStatus)"
+ " Values('" + FieldValues.GetValue(0) + "'"
+ ",'" + FieldValues.GetValue(1) + "'"
+ "," + ConsumeType_ConsumeValue.ToString()
+ ",GetDate()"
+ "," + SysGlobal.GetCurrentUserOrganID().ToString()
+ "," + FieldValues.GetValue(2) + ""
+ "," + SysGlobal.GetCurrentUserID().ToString() + ""
+ ",'" + FieldValues.GetValue(5) + "'"
+ ",'" + FieldValues.GetValue(3) + "'"
+ "," + FieldValues.GetValue(4) + ")";
sSqlText = sSqlText + Sql + " ;";
}
return(DataCommon.QueryData(sSqlText));
}
//更新添加工具档案信息
public static int UpdateSinglePurchaseOrder(int _ID, string[] FieldValues, string DetailsSQL)
{
string sSqlText = "begin";
if (_ID > 0)
{
sSqlText = sSqlText + " UPDATE PurchaseOrder_Info SET OrderNo='" + FieldValues.GetValue(1)
+ "',SupplierID=" + FieldValues.GetValue(2)
+ ",Description='" + FieldValues.GetValue(3) + "'"
+ ",ApprovalStatus='" + FieldValues.GetValue(4) + "'"
+ ",TotalAmount=" + FieldValues.GetValue(5);
sSqlText = sSqlText + " WHERE ID=" + _ID + "" + ";";
sSqlText += " ;";
}
else
{
sSqlText = sSqlText + " Insert Into PurchaseOrder_Info (TableRecGuid"
+ ", OrderNo"
+ ", OrderDate"
+ ", SupplierID"
+ ", OrderOrganID"
+ ", OrderUserID"
+ ", Description"
+ ", ApprovalStatus"
+ ", TotalAmount)"
+ " Values('" + FieldValues.GetValue(0) + "'"
+ ",'" + FieldValues.GetValue(1) + "'"
+ ",GetDate()"
+ "," + FieldValues.GetValue(2)
+ "," + SysGlobal.GetCurrentUserOrganID().ToString()
+ ",'" + SysGlobal.GetCurrentUserID().ToString() + "'"
+ ",'" + FieldValues.GetValue(3) + "'"
+ ",'" + FieldValues.GetValue(4) + "'"
+ "," + FieldValues.GetValue(5) + ")";
sSqlText += " ;";
}
sSqlText = sSqlText + DetailsSQL
+ " end;";
return(DataCommon.QueryData(sSqlText));
}
//发货单保存修改
public static int UpUserShiply(int _ID, string[] FieldValues, string Sql)
{
string sSqlText = "";
if (_ID > 0)
{
sSqlText = sSqlText + " UPDATE InterphoneShip_Info SET ShipNo='" + FieldValues.GetValue(1) + "'"
+ ", Isfinish=" + FieldValues.GetValue(5)
+ ", Description='" + FieldValues.GetValue(4) + "'";
sSqlText = sSqlText + " WHERE ID=" + _ID + "" + ";";
sSqlText = sSqlText + Sql + " ;";
}
else
{
sSqlText = sSqlText + " Insert Into InterphoneShip_Info (TableRecGuid"
+ ", ShipNo"
+ ", Quantity"
+ ", ActionUserID"
+ ", Shipdate"
+ ", ShipOrganID"
+ ", Isfinish"
+ ", OrderInfoID"
+ ", Mode"
+ ", Description)"
+ " Values('" + FieldValues.GetValue(0) + "'"
+ ",'" + FieldValues.GetValue(1) + "'"
+ ",'" + FieldValues.GetValue(2) + "'"
+ "," + SysGlobal.GetCurrentUserID().ToString() + ""
+ ",GetDate()"
+ "," + FieldValues.GetValue(3) + ""
+ "," + FieldValues.GetValue(5) + ""
+ "," + FieldValues.GetValue(6) + ""
+ ",'" + FieldValues.GetValue(7) + "'"
+ ",'" + FieldValues.GetValue(4) + "')";
sSqlText = sSqlText + Sql + " ;";
}
return(DataCommon.QueryData(sSqlText));
}
//更新添加工具档案信息
public static int UpdateSingleInventory(int _InventoryID, string[] FieldValues, string DetailsSQL)
{
string sSqlText = "begin";
if (_InventoryID > 0)
{
sSqlText = sSqlText + " UPDATE Inventory_Info SET InventoryNo='" + FieldValues.GetValue(1) + "'"
+ ",InventoryUserID=" + FieldValues.GetValue(2) + ""
+ ",Description='" + FieldValues.GetValue(3) + "'"
+ ",ApprovalStatus='" + FieldValues.GetValue(4) + "'";
sSqlText = sSqlText + " WHERE ID=" + _InventoryID + "" + ";";
sSqlText += " ;";
}
else
{
sSqlText = sSqlText + " Insert Into Inventory_Info (TableRecGuid"
+ ", InventoryNo"
+ ", InventoryDate"
+ ", OrganID"
+ ", InventoryUserID"
+ ", CreateUserID"
+ ", Description"
+ ", ApprovalStatus)"
+ " Values('" + FieldValues.GetValue(0) + "'"
+ ",'" + FieldValues.GetValue(1) + "'"
+ ",GetDate()"
+ "," + SysGlobal.GetCurrentUserOrganID().ToString()
+ "," + FieldValues.GetValue(2) + ""
+ "," + SysGlobal.GetCurrentUserID().ToString() + ""
+ ",'" + FieldValues.GetValue(3) + "'"
+ "," + FieldValues.GetValue(4) + ")";
sSqlText = sSqlText + " ;";
}
sSqlText = sSqlText + DetailsSQL
+ " end;";
return(DataCommon.QueryData(sSqlText));
}
