Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API
| | |
| | | public string HRemark; //夿³¨ |
| | | |
| | | |
| | | public Int64 HQtyMust; //åºåæ°é |
| | | public decimal HQtyMust; //åºåæ°é |
| | | public double HNumerator; //åå |
| | | public double HDenominator; //忝 |
| | | public double HQtyScrap; //æèç |
| | |
| | | public double HMoney;// dec(18,8) --åå¸éé¢ |
| | | public double HTaxPrice;// dec(18,8) --å«ç¨åä»· |
| | | public double HTaxMoney;// dec(18,8) --å«ç¨éé¢ |
| | | public double HTaxRate;// dec(18,8) --å«ç¨éé¢ |
| | | public double HTaxMoney_TAX;// dec(18,8) --å«ç¨éé¢ |
| | | public double HTaxRate_TAX;// dec(18,8) --å«ç¨éé¢ |
| | | public Int64 HWHID;// --æ¶æä»åº |
| | | public Int64 HPOOrderInterID;// |
| | | public Int64 HPOOrderEntryID;// |
| | |
| | | public double HPrice;// dec(18,8) //åå¸åä»· |
| | | public double HMoney;// dec(18,8) //åå¸éé¢ |
| | | public Single HTaxRate;// money //ç¨ç |
| | | public Single HTaxRate_TAX;// money //ç¨ç |
| | | public Single HTaxMoney_TAX;// money //ç¨ç |
| | | public double HTaxPrice; //å«ç¨åä»· |
| | | public double HTaxMoney;// dec(18,8) //ç¨é¢=åå¸éé¢*ç¨ç |
| | | public double HlineTotal;// dec(18,8) //ä»·ç¨å计=åå¸éé¢+ç¨é¢ |
| | |
| | | |
| | | namespace Pub_Class |
| | | { |
| | | public class ClsSqlHelper:IDisposable |
| | | public class ClsSqlHelper : IDisposable |
| | | { |
| | | private SqlConnection MainCn;//åå»ºè¿æ¥å¯¹è±¡ |
| | | public string strCon; |
| | | SqlTransaction MainTran; |
| | | public string sServer; |
| | | public string sDataBase ; |
| | | public string sDataBase; |
| | | public string sUser; |
| | | public string sPassword; |
| | | //public string sTextBox = "HXErp_Test.ini"; |
| | | public string sTextBox = "HXErp.ini"; |
| | | //å¼å§äºå¡ |
| | | public void BeginTran() |
| | | public void BeginTran() |
| | | { |
| | | if (!this.CnOpen()) |
| | | return; |
| | | MainTran=MainCn.BeginTransaction(); |
| | | MainTran = MainCn.BeginTransaction(); |
| | | } |
| | | //ç»æäºå¡ |
| | | public void Commit() |
| | |
| | | ClsPub.AppPath = System.Environment.CurrentDirectory; |
| | | //ClsPub.AppPath = @"C:\Windows\System32"; |
| | | } |
| | | sServer = ClsIni.ReadIni("Erp", "Server", ClsPub.AppPath + @"\"+sTextBox); |
| | | sServer = ClsIni.ReadIni("Erp", "Server", ClsPub.AppPath + @"\" + sTextBox); |
| | | sDataBase = ClsIni.ReadIni("Erp", "DataBase", ClsPub.AppPath + @"\" + sTextBox); |
| | | sUser = ClsIni.ReadIni("Erp", "UserName", ClsPub.AppPath + @"\" + sTextBox); |
| | | sPassword = ClsIni.ReadIni("Erp", "PassWord", ClsPub.AppPath + @"\" + sTextBox); |
| | |
| | | |
| | | public bool CheckOpen() |
| | | { |
| | | if (sServer == "" || sServer == "æ²¡ææ¾å°ï¼" ) |
| | | if (sServer == "" || sServer == "æ²¡ææ¾å°ï¼") |
| | | { |
| | | throw new Exception("é误çæå¡å¨å!!" + System.Environment.CurrentDirectory); |
| | | } |
| | | if (sDataBase == "" || sDataBase == "æ²¡ææ¾å°ï¼") |
| | | { |
| | | throw new Exception("éè¯¯çæ°æ®åºå!!" +System.Environment.CurrentDirectory); |
| | | throw new Exception("éè¯¯çæ°æ®åºå!!" + System.Environment.CurrentDirectory); |
| | | } |
| | | SqlConnection oCn = new SqlConnection("Data Source=" + sServer + ";DataBase=master;User ID=" + sUser + ";PWD=" + sPassword + ";max pool size=32767"); |
| | | try |
| | |
| | | } |
| | | } |
| | | |
| | | private bool CnOpen()//OPENæ°æ®åºè¿æ¥ |
| | | private bool CnOpen()//OPENæ°æ®åºè¿æ¥ |
| | | { |
| | | if (sServer == "" || sServer == "æ²¡ææ¾å°ï¼") |
| | | { |
| | |
| | | { |
| | | throw new Exception("éè¯¯çæ°æ®åºå!"); |
| | | } |
| | | if (MainCn==null) |
| | | if (MainCn == null) |
| | | { |
| | | MainCn = new SqlConnection("Data Source=" + sServer + ";DataBase=" + sDataBase + ";User ID=" + sUser + ";PWD=" + sPassword + ";max pool size=32767"); |
| | | } |
| | |
| | | |
| | | public void CnDispose()//éæ¾èµæº |
| | | { |
| | | if(MainCn!=null) |
| | | { |
| | | if (MainCn != null) |
| | | { |
| | | MainCn.Dispose(); |
| | | MainCn=null; |
| | | MainCn = null; |
| | | } |
| | | } |
| | | /// <summary> |
| | |
| | | /// <returns>æ°ç parameter 对象</returns> |
| | | public SqlParameter MakeInParam(string ParamName, SqlDbType DbType, int Size, object Value) |
| | | { |
| | | return MakeParam(ParamName, DbType, Size, ParameterDirection.Input, Value); |
| | | return MakeParam(ParamName, DbType, Size, ParameterDirection.Input, Value); |
| | | } |
| | | /// <summary> |
| | | /// åå§ååæ°å¼ |
| | |
| | | /// <param name="procName"></param> |
| | | /// <param name="sErrMessage"></param> |
| | | /// <returns></returns> |
| | | public void RunProc(string procName,ref string sErr) |
| | | public void RunProc(string procName, ref string sErr) |
| | | { |
| | | if (!this.CnOpen()) |
| | | { |
| | | sErr = "è¿æ¥æ°æ®åºå¤±è´¥ï¼"; |
| | | return; |
| | | |
| | | |
| | | } |
| | | try |
| | | { |
| | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sErr =e.Message; |
| | | sErr = e.Message; |
| | | ClsPub.sErrInfo = e.Message; |
| | | throw (e); |
| | | //return; |
| | |
| | | /// <param name="tbName">表å</param> |
| | | /// <param name="sErrMessage">å¼å¸¸ä¿¡æ¯</param> |
| | | /// <returns></returns> |
| | | public DataSet RunProcReturn(string procName, SqlParameter[] prams, string tbName ) |
| | | public DataSet RunProcReturn(string procName, SqlParameter[] prams, string tbName) |
| | | { |
| | | SqlDataAdapter dap = CreateDataAdaper(procName, prams); |
| | | if (dap == null) |
| | |
| | | /// <param name="tbName">表å</param> |
| | | /// <param name="sErrMessage">å¼å¸¸ä¿¡æ¯</param> |
| | | /// <returns></returns> |
| | | public DataSet RunProcReturn(string procName, string tbName ) |
| | | public DataSet RunProcReturn(string procName, string tbName) |
| | | { |
| | | SqlDataAdapter dap = CreateDataAdaper(procName, null); |
| | | DataSet ds = new DataSet(); |
| | |
| | | /// <param name="tbName">表å</param> |
| | | /// <param name="sErrMessage">å¼å¸¸ä¿¡æ¯</param> |
| | | /// <returns></returns> |
| | | public DataSet RunProcReturn(string procName, string tbName,ref string sErr) |
| | | public DataSet RunProcReturn(string procName, string tbName, ref string sErr) |
| | | { |
| | | SqlDataAdapter dap = CreateDataAdaper(procName, null); |
| | | DataSet ds = new DataSet(); |
| | |
| | | |
| | | } |
| | | |
| | | public SqlDataReader RunReader(string sSQL,string tbName,ref string sErr) |
| | | public SqlDataReader RunReader(string sSQL, string tbName, ref string sErr) |
| | | { |
| | | if (!this.CnOpen()) |
| | | { |
| | |
| | | catch (Exception e) |
| | | { |
| | | ClsPub.sErrInfo = e.Message; |
| | | sErr = e.Message; |
| | | sErr = e.Message; |
| | | return null; |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// æ¹éæå
¥æ°æ®åº |
| | | /// </summary> |
| | | /// <param name="TableName">ç®æ 表</param> |
| | | /// <param name="dt">æºæ°æ®</param> |
| | | public bool SqlBulkCopyByDatatable(string TableName, DataTable dt) |
| | | { |
| | | string connectionString = $"Data Source={sServer};DataBase={sDataBase};User ID={sUser};PWD={sPassword}"; |
| | | using (SqlConnection conn = new SqlConnection(connectionString)) |
| | | { |
| | | using (SqlBulkCopy sqlbulkcopy = new SqlBulkCopy(connectionString, SqlBulkCopyOptions.UseInternalTransaction)) |
| | | { |
| | | try |
| | | { |
| | | sqlbulkcopy.DestinationTableName = TableName; |
| | | for (int i = 0; i < dt.Columns.Count; i++) |
| | | { |
| | | sqlbulkcopy.ColumnMappings.Add(dt.Columns[i].ColumnName, dt.Columns[i].ColumnName); |
| | | } |
| | | sqlbulkcopy.WriteToServer(dt); |
| | | return true; |
| | | } |
| | | catch (System.Exception ex) |
| | | { |
| | | //ex.Message; |
| | | return false; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | #region IDisposable æå |
| | | |
| | | public void Dispose() |
| | |
| | | using Newtonsoft.Json; |
| | | using Model; |
| | | using Newtonsoft.Json; |
| | | using Newtonsoft.Json.Linq; |
| | | using NPOI.SS.Formula.Functions; |
| | | using Pub_Class; |
| | | using System; |
| | | using System.Collections; |
| | |
| | | using System.Data; |
| | | using System.Data.SqlClient; |
| | | using System.Web.Http; |
| | | using WebAPI.Controllers.SCGL.æ¥è®¡å管ç; |
| | | using WebAPI.Models; |
| | | using WebAPI.Service; |
| | | |
| | |
| | | using Newtonsoft.Json; |
| | | using Model; |
| | | using Newtonsoft.Json; |
| | | using Newtonsoft.Json.Linq; |
| | | using Pub_Class; |
| | | using System; |
| | |
| | | using System.Data; |
| | | using System.Data.SqlClient; |
| | | using System.Web.Http; |
| | | using WebAPI.Controllers.SCGL.æ¥è®¡å管ç; |
| | | using WebAPI.Models; |
| | | namespace WebAPI.Controllers |
| | | { |
| | |
| | | long HParentID = list[0].HParentID; |
| | | long HLevel = list[0].HLevel; |
| | | bool HEndFlag = list[0].HEndFlag; |
| | | bool HStopflag = list[0].HStopflag; |
| | | bool HStopflag = list[0].HStopFlag; |
| | | string HRemark = list[0].HRemark; |
| | | string HBarCode = list[0].HBarCode; |
| | | long HEmpID = list[0].HEmpID; |
| | |
| | | long HParentID = list[0].HParentID; |
| | | long HLevel = list[0].HLevel; |
| | | bool HEndFlag = list[0].HEndFlag; |
| | | bool HStopflag = list[0].HStopflag; |
| | | bool HStopflag = list[0].HStopFlag; |
| | | string HRemark = list[0].HRemark; |
| | | string HBarCode = list[0].HBarCode; |
| | | long HEmpID = list[0].HEmpID; |
| | |
| | | _value = "[" + _value.ToString() + "]"; |
| | | List<Warehouse> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Warehouse>>(_value); |
| | | string sql = string.Empty; |
| | | //DataTable dt = DataHelper.ListToDataTable<Warehouse>(list); |
| | | //oCN.SqlBulkCopyByDatatable("Gy_Warehouse", dt); |
| | | //ä¿å |
| | | oCN.BeginTran(); |
| | | sql = $"delete Gy_Warehouse where HItemID = {list[0].HItemID}"; |
| | |
| | | " (HItemID,HNumber,HName,HHelpCode,HShortNumber,HParentID" + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HEmpID,HAddress,HPhone,HUSEORGID) " + |
| | | " Values('" + list[0].HItemID + "','" + list[0].HNumber + "','" +list[0].HName + "','" + list[0].HHelpCode + "','" + list[0].HShortNumber + "'," + list[0].HParentID.ToString() + |
| | | "," + list[0].HLevel.ToString() + "," + Convert.ToString(list[0].HEndFlag ? 1 : 0) + "," + Convert.ToString(list[0].HStopflag ? 1 : 0) + ",'" + list[0].HRemark + "'," + list[0].HEmpID.ToString() + ",'" + list[0].HAddress + "','" + list[0].HPhone + "','" + list[0].HUSEORGID + "')", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | "," + list[0].HLevel.ToString() + "," + Convert.ToString(list[0].HEndFlag ? 1 : 0) + "," + Convert.ToString(list[0].HStopFlag ? 1 : 0) + ",'" + list[0].HRemark + "'," + list[0].HEmpID.ToString() + ",'" + list[0].HAddress + "','" + list[0].HPhone + "','" + list[0].HUSEORGID + "')", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | | sql = "set identity_insert Gy_Warehouse off"; |
| | | oCN.RunProc(sql); |
| | |
| | | //ååºåå |
| | | msg2 = "[" + msg2.ToString() + "]"; |
| | | List<WorkDay> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<WorkDay>>(msg2); |
| | | |
| | | long HItemID = list[0].HItemID; |
| | | |
| | | //ä¿å |
| | | //ä¿å宿¯åå¤ç |
| | | if (HItemID == 0) |
| | | { |
| | | oCN.BeginTran(); |
| | | string sql = string.Format(@"insert into Gy_WorkDay (HDate,HWorkBegin,HWorkEnd,HNoonbreakBegin,HNoonbreakEnd,HNightbreakBegin,HNightbreakEnd) |
| | | values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", list[0].HDate, list[0].HWorkBegin, list[0].HWorkEnd, list[0].HNoonbreakBegin, list[0].HNoonbreakEnd, list[0].HNightbreakBegin, list[0].HNightbreakEnd); |
| | | string sql = string.Format(@"insert into Gy_WorkDay (HDate,HWorkBegin,HWorkEnd,HNoonbreakBegin,HNoonbreakEnd,HNightbreakBegin,HNightbreakEnd,HNoonbreakBegin2,HNoonbreakEnd2,HNightbreakBegin2,HNightbreakEnd2) |
| | | values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')", list[0].HDate, list[0].HWorkBegin, list[0].HWorkEnd, list[0].HNoonbreakBegin, list[0].HNoonbreakEnd, list[0].HNightbreakBegin, list[0].HNightbreakEnd, list[0].HNoonbreakBegin2, list[0].HNoonbreakEnd2, list[0].HNightbreakBegin2, list[0].HNightbreakEnd2); |
| | | oCN.RunProc(sql); |
| | | oCN.Commit(); |
| | | } |
| | |
| | | ",HWorkBegin='" + list[0].HWorkBegin + "'" + |
| | | ",HWorkEnd='" + list[0].HWorkEnd + "'" + |
| | | ",HNoonbreakBegin='" + list[0].HNoonbreakBegin + "'" + |
| | | ",HNoonbreakEnd=" + list[0].HNoonbreakEnd + |
| | | ",HNightbreakBegin=" + list[0].HNightbreakBegin + |
| | | ",HNightbreakEnd=" + list[0].HNightbreakEnd + |
| | | ",HNoonbreakEnd='" + list[0].HNoonbreakEnd + "'" + |
| | | ",HNightbreakBegin='" + list[0].HNightbreakBegin + "'" + |
| | | ",HNightbreakEnd='" + list[0].HNightbreakEnd + "'" + |
| | | ",HNoonbreakBegin2='" + list[0].HNoonbreakBegin2 + "'" + |
| | | ",HNoonbreakEnd2='" + list[0].HNoonbreakEnd2 + "'" + |
| | | ",HNightbreakBegin2='" + list[0].HNightbreakBegin2 + "'" + |
| | | ",HNightbreakEnd2='" + list[0].HNightbreakEnd2 + "'" + |
| | | " Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | // |
| | | oCN.Commit(); |
| | |
| | | /// </summary> |
| | | [Route("Cg_POInStockBill/list")] |
| | | [HttpGet] |
| | | public object list(string sWhere,string user) |
| | | public object list(string sWhere, string user) |
| | | { |
| | | try |
| | | { |
| | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_POInStockBillList order by hmainid desc" , "h_v_IF_POInStockBillList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_POInStockBillList order by hmainid desc", "h_v_IF_POInStockBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_IF_POInStockBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere+ " order by æ¥æ desc,hmainid desc"; |
| | | string sql = sql1 + sWhere + " order by æ¥æ desc,hmainid desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_POInStockBillList"); |
| | | } |
| | | |
| | |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | ///å é¤åè½ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("Cg_POInStockBill/DeltetPOInStockBill")] |
| | | [HttpGet] |
| | | public object DeltetPOInStockBill(string HInterID,string user) |
| | | public object DeltetPOInStockBill(string HInterID, string user) |
| | | { |
| | | try |
| | | { |
| | |
| | | /// </summary> |
| | | [Route("Cg_POInStockBill/DeAuditPOInStockBill")] |
| | | [HttpGet] |
| | | public object DeAuditPOInStockBill(string HInterID,string user) |
| | | public object DeAuditPOInStockBill(string HInterID, string user) |
| | | { |
| | | try |
| | | { |
| | |
| | | Ids = "" |
| | | }; |
| | | var loginRet = InvokeHelper.Login(); |
| | | |
| | | |
| | | var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>(); |
| | | if (isSuccess == 0) |
| | | { |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | #endregion |
| | | [Route("Cg_POInStockBill/Cg_POInStockBillSaveApi")] |
| | | [HttpPost] |
| | | public object Cg_POInStockBillSaveApi([FromBody] JObject sMainSub) |
| | | { |
| | | try |
| | | { |
| | | var model = sMainSub["model"].ToString(); |
| | | var entry = sMainSub["model"]["HENTRY"].ToString(); |
| | | |
| | | model = "[" + model.ToString() + "]"; |
| | | List<ClsCg_POInStockBillMain> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsCg_POInStockBillMain>>(model); |
| | | List<ClsCg_POInStockBillSub> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsCg_POInStockBillSub>>(entry); |
| | | string sql = string.Empty; |
| | | oCN.BeginTran(); |
| | | sql = $"delete Cg_POInStockBillMain where HinterID = {mainList[0].HInterID}"; |
| | | oCN.RunProc(sql); |
| | | sql = $"delete Cg_POInStockBillMain where HinterID = {mainList[0].HInterID}"; |
| | | oCN.RunProc(sql); |
| | | //主表 |
| | | sql = @" |
| | | Insert Into Cg_POInStockBillMain |
| | | (HInterID,HYear,HPeriod,HBillType,HBillSubType,HDate |
| | | ,HBillNo,HBillStatus,HSupID,HManagerID,HEmpID,HDeptID,HRemark |
| | | ,HMaker,HMakeDate,HChecker,HCheckDate,HOWNERTYPEID,HOWNERID |
| | | ,HERPInterID,HERPBillType,HPURCHASEORGID,HSTOCKORGID,HREQUIREORGID |
| | | ,HSTOCKGROUPID,HSENDBILLNO,HLADBILLNO,HPURDEPTID,HPURGROUPID,HSUPPLYID |
| | | ,HSETTLEID,HCHARGEID,HBUSINESSTYPE,HSUPPLYADDRESS,HCORRESPONDORGID,HPROVIDERCONTACTID,HCurID,HExRate,HAddress,HWHID) |
| | | values(" + mainList[0].HInterID + "," + DateTime.Now.Year + "," + DateTime.Now.Month + ",'" + 1103 + "','" + |
| | | mainList[0].HBillSubType + "','" + mainList[0].HDate + "','" + mainList[0].HBillNo + "'," + mainList[0].HBillStatus + "," + mainList[0].HSupID + |
| | | "," + mainList[0].HManagerID + "," + mainList[0].HEmpID + "," + mainList[0].HDeptID + ",'" + mainList[0].HRemark + "','" + mainList[0].HMaker + |
| | | "','" + mainList[0].HMakeDate + "','" + mainList[0].HChecker + "','" + mainList[0].HCheckDate + "','" + mainList[0].HOWNERTYPEID + "'," + mainList[0].HOWNERID + "," + mainList[0].HERPInterID + ",'" + mainList[0].HERPBillType + "'," + mainList[0].HPURCHASEORGID + "," + mainList[0].HSTOCKORGID + "," + mainList[0].HREQUIREORGID + "," + |
| | | mainList[0].HSTOCKGROUPID + ",'" + mainList[0].HSENDBILLNO + "','" + mainList[0].HLADBILLNO + "'," + mainList[0].HPURDEPTID + "," + mainList[0].HPURGROUPID + "," + mainList[0].HSUPPLYID + "," + |
| | | mainList[0].HSETTLEID + "," + mainList[0].HCHARGEID + ",'" + mainList[0].HBUSINESSTYPE + "','" + mainList[0].HSUPPLYADDRESS + "'," + mainList[0].HCORRESPONDORGID + "," + mainList[0].HPROVIDERCONTACTID + "," + mainList[0].HCurID + "," + mainList[0].HExRate + ",'" + mainList[0].HAddress + "'," + mainList[0].HWHID + ")"; |
| | | oCN.RunProc(sql); |
| | | //ä¿å主表 |
| | | foreach (var oSub in subList) |
| | | { |
| | | sql = $@" |
| | | Insert into Cg_POInStockBillSub |
| | | (HInterID,HEntryID,HMaterID,HUnitID,HQty,HPrice |
| | | ,HMoney,HWHID,HSPID,HRemark,HTaxMoney,HTaxRate,HTaxMoney_TAX,HTaxRate_TAX |
| | | ,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HPOOrderInterID |
| | | ,HPOOrderEntryID,HPOORderBillNo,HAuxPropID,HBatchNO,HMTONo,HPlanMode,HERPInterID,HERPEntryID |
| | | ,HRelationQty,HGiveAwayFlag,HReceiveQty,HSEQ,HPRODUCEDATE,HEXPIRYDATE,HSUPPLYLOT,HREQTRACENO,HBOMID,HSTOCKUNITID |
| | | ,HBASEUNITID,HSTOCKSTATUSID,HKEEPERTYPEID,HPROJECTNO,HCHECKINCOMING,HTAXPRICE,HDISCOUNTRATE |
| | | ,HPRICECOEFFICIENT,HPRICEUNITID,HPRICELISTENTRY,HSAMPLEDAMAGEQTY,HSAMPLEDAMAGEBASEQTY |
| | | ,HPAYORGID,HSETTLEORGID,HSETTLECURRID,HSETTLEMODEID,HEXCHANGETYPEID,HPAYCONDITONID |
| | | ,HEXCHANGERATE,HLOCALCURRID,HISINCLUDEDTAX,HISPRICEEXCLUDETAX |
| | | ,HTAXRATEID,HCOSTPERCENT,HCOSTAMOUNT,HVAT,HSELLERWITHHOLDING,HBUYERWITHHOLDING,HSecUnitID) |
| | | values( |
| | | '{oSub.HInterID}','{oSub.HEntryID}','{oSub.HMaterID}','{oSub.HUnitID}','{oSub.HQty}','{oSub.HPrice}' |
| | | ,'{oSub.HMoney}','{oSub.HWHID}','{oSub.HSPID}','{oSub.HRemark}','{oSub.HTaxMoney}','{oSub.HTaxRate}','{oSub.HTaxMoney_TAX}','{oSub.HTaxRate_TAX}' |
| | | ,'{oSub.HSourceInterID}','{oSub.HSourceEntryID}','{oSub.HSourceBillNo}','{oSub.HSourceBillType}','{oSub.HPOOrderInterID}','{oSub.HPOOrderEntryID}','{oSub.HPOOrderBillNo}','{oSub.HAuxPropID}','{oSub.HBatchNO}','{oSub.HMTONo}','{oSub.HPlanMode}','{oSub.HERPInterID}','{oSub.HERPEntryID}','{oSub.HRelationQty}','{oSub.HGiveAwayFlag}','{oSub.HReceiveQty}','{oSub.HSEQ}','{oSub.HPRODUCEDATE}','{oSub.HEXPIRYDATE}', |
| | | '{oSub.HSUPPLYLOT}','{oSub.HREQTRACENO}','{oSub.HBOMID}','{oSub.HSTOCKUNITID}','{oSub.HBASEUNITID}','{oSub.HSTOCKSTATUSID}','{oSub.HKEEPERTYPEID}','{oSub.HPROJECTNO}','{oSub.HCHECKINCOMING}','{oSub.HTaxPrice}','{oSub.HDISCOUNTRATE}','{oSub.HPRICECOEFFICIENT}','{oSub.HPRICEUNITID}','{oSub.HPRICELISTENTRY}','{oSub.HSAMPLEDAMAGEQTY}','{oSub.HSAMPLEDAMAGEBASEQTY}','{oSub.HPAYORGID}','{oSub.HSETTLEORGID}','{oSub.HSETTLECURRID}','{oSub.HSETTLEMODEID}','{oSub.HEXCHANGETYPEID}','{oSub.HPAYCONDITONID}','{oSub.HEXCHANGERATE}','{oSub.HLOCALCURRID}','{oSub.HISINCLUDEDTAX}','{oSub.HISPRICEEXCLUDETAX}','{oSub.HTAXRATEID}','{oSub.HCOSTPERCENT}','{oSub.HCOSTAMOUNT}','{oSub.HVAT}','{oSub.HSELLERWITHHOLDING}','{oSub.HBUYERWITHHOLDING}','{oSub.HSecUnitID}')"; |
| | | oCN.RunProc(sql); |
| | | } |
| | | oCN.Commit(); |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "åæ®ä¿åæåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | } |
| | | } |
| | |
| | | HBillSubType + "','" + HDate + "','" + HBillNo + "','" + HBillStatus + "','" + HAddress + |
| | | "'," + HSSID + ",'" + HSSDate + "'," + HPSStyleID + "," + HSupID + "," + HCurID + |
| | | "," + HExRate + "," + HEmpID + "," + HManagerID + "," + HDeptID + ",'" + HExplanation + "','" + HRemark + "','" + HInnerBillNo + "','" + HChecker + "','" + HCheckDate + "','" + HMaker + "','" + |
| | | HMakeDate + "'," + HERPInterID + ",'" + HERPBillType + "'," + HPURCHASEORGID + "," + HPURCHASERGROUPID + "," |
| | | HMakeDate + "'," + HERPInterID + ",'" + HERPBillType + "'," + HPURCHASEORGID + "," + HPURCHASERGROUPID + "," |
| | | + HPROVIDERID + "," + HSETTLEID + "," + HCHARGEID + ",'" + HBUSINESSTYPE + "','" + HPROVIDERADDRESS + "'," |
| | | + HCORRESPONDORGID + "," + HPROVIDERCONTACTID + ")"); |
| | | } |
| | |
| | | |
| | | List<ClsCg_POOrderBillSub> DetailColl2 = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsCg_POOrderBillSub>>(msg3); |
| | | |
| | | |
| | | |
| | | string HSourceBillNo = DetailColl2[0].HSourceBillNo == null ? "''" : DetailColl2[0].HSourceBillNo; |
| | | string HSourceBillType = DetailColl2[0].HSourceBillType == null ? "''" : DetailColl2[0].HSourceBillType; |
| | | double HRelationQty = DetailColl2[0].HRelationQty == null ? 0 : DetailColl2[0].HRelationQty; |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | |
| | | [Route("Cg_POOrderBill/Cg_POOrderBillSaveApi")] |
| | | [HttpPost] |
| | | public object Cg_POOrderBillSaveApi([FromBody] JObject sMainSub) |
| | | { |
| | | try |
| | | { |
| | | var model = sMainSub["model"].ToString(); |
| | | var entry = sMainSub["model"]["HENTRY"].ToString(); |
| | | |
| | | model = "[" + model.ToString() + "]"; |
| | | List<ClsCg_POOrderBillMain> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsCg_POOrderBillMain>>(model); |
| | | List<ClsCg_POOrderBillSub> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsCg_POOrderBillSub>>(entry); |
| | | string sql = string.Empty; |
| | | oCN.BeginTran(); |
| | | sql = $"delete Cg_POOrderBillMain where HinterID = {mainList[0].HInterID}"; |
| | | oCN.RunProc(sql); |
| | | sql = $"delete Cg_POOrderBillSub where HinterID = {mainList[0].HInterID}"; |
| | | oCN.RunProc(sql); |
| | | //主表 |
| | | oCN.RunProc(@"Insert Into Cg_POOrderBillMain |
| | | (HInterID,HYear,HPeriod,HBillType,HBillSubType,HDate,HBillNo,HBillStatus |
| | | ,HAddress,HSSID,HSSDate,HPSStyleID,HSupID,HCurID |
| | | ,HExRate,HEmpID,HManagerID,HDeptID,HExplanation,HRemark,HInnerBillNo |
| | | ,HChecker,HCheckDate,HMaker,HMakeDate |
| | | ,HERPInterID,HERPBillType,HPURCHASEORGID |
| | | ,HPURCHASERGROUPID,HPROVIDERID,HSETTLEID,HCHARGEID,HBUSINESSTYPE,HPROVIDERADDRESS,HCORRESPONDORGID,HPROVIDERCONTACTID) |
| | | values(" + mainList[0].HInterID + "," + DateTime.Now.Year + "," + DateTime.Now.Month + ",'" + 1102 + "','" + |
| | | mainList[0].HBillSubType + "','" + mainList[0].HDate + "','" + mainList[0].HBillNo + "','" + mainList[0].HBillStatus + "','" + mainList[0].HAddress + |
| | | "'," + mainList[0].HSSID + ",'" + mainList[0].HSSDate + "'," + mainList[0].HPSStyleID + "," + mainList[0].HSupID + "," + mainList[0].HCurID + |
| | | "," + mainList[0].HExRate + "," + mainList[0].HEmpID + "," + mainList[0].HManagerID + "," + mainList[0].HDeptID + ",'" + mainList[0].HExplanation + "','" + mainList[0].HRemark + "','" + mainList[0].HInnerBillNo + "','" + mainList[0].HChecker + "','" + mainList[0].HCheckDate + "','" + mainList[0].HMaker + "','" + |
| | | mainList[0].HMakeDate + "'," + mainList[0].HERPInterID + ",'" + mainList[0].HERPBillType + "'," + mainList[0].HPURCHASEORGID + "," + mainList[0].HPURCHASERGROUPID + "," |
| | | + mainList[0].HPROVIDERID + "," + mainList[0].HSETTLEID + "," + mainList[0].HCHARGEID + ",'" + mainList[0].HBUSINESSTYPE + "','" + mainList[0].HPROVIDERADDRESS + "'," |
| | | + mainList[0].HCORRESPONDORGID + "," + mainList[0].HPROVIDERCONTACTID + ")"); |
| | | //ä¿å主表 |
| | | foreach (var oSub in subList) |
| | | { |
| | | sql = $@" |
| | | Insert into Cg_POOrderBillSub |
| | | (HInterID,HEntryID,HMaterID,HUnitID,HQty,HPrice,HTaxRate_TAX,HTaxMoney_TAX,HTaxPrice,HDiscountRate,HRelTaxPrice |
| | | ,HMoney,HTaxRate,HTaxMoney,HLineTotal,HlineTotalBB,HDate,HInStockQty,HInvoiceQty,HSeOrderBillNo,HSeOrderInterID |
| | | ,HSeOrderEntryID,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo |
| | | ,HSourceBillType,HRelationQty,HBackRelationQty,HPropertyID,HBatChNo,HAuxPropID,HMTONo |
| | | ,HERPInterID,HERPEntryID |
| | | ,HSEQ,HRECEIVEDEPTID,HSUPPLIERLOT,HBOMID,HSTOCKUNITID,HBASEUNITID,HBFLOWID,HGIVEAWAY,HROWTYPE,HBASEUNITQTY,HSTOCKBASEQTY |
| | | ,HREQTRACENO,HTAXNETPRICE,HPRICECOEFFICIENT,HTAXCOMBINATION,HPRICEUNITID,HPRICELISTENTRY,HPAYORGID,HSETTLEMODEID,HSETTLECURRID |
| | | ,HEXCHANGETYPEID,HPAYCONDITIONID,HEXCHANGERATE,HLOCALCURRID,HISINCLUDEDTAX,HISPRICEEXCLUDETAX,HTAXRATEID,HCOSTPERCENT,HCOSTAMOUNT |
| | | ,HVAT,HSELLERWITHHOLDING,HBUYERWITHHOLDING,HMATERIALDESC) |
| | | values('{oSub.HInterID}','{oSub.HEntryID}','{oSub.HMaterID}','{oSub.HUnitID}','{oSub.HQty}','{oSub.HPrice}','{oSub.HPrice}','{oSub.HTaxRate_TAX}','{oSub.HTaxMoney_TAX}','{oSub.HDiscountRate}','{oSub.HRelTaxPrice}', |
| | | '{oSub.HMoney}','{oSub.HTaxRate}','{oSub.HTaxMoney}','{oSub.HlineTotal}','{oSub.HlineTotalBB}','{oSub.HDate}','{oSub.HInStockQty}','{oSub.HInvoiceQty}','{oSub.HSeOrderBillNo}','{oSub.HSeOrderInterID}', |
| | | '{oSub.HSeOrderEntryID}','{oSub.HRemark}','{oSub.HSourceInterID}','{oSub.HSourceEntryID}','{oSub.HSourceBillNo}', |
| | | '{oSub.HSourceBillType}','{oSub.HRelationQty}','{oSub.HBackRelationQty}','{oSub.HPropertyID}','{oSub.HBatChNo}','{oSub.HAuxPropID}','{oSub.HMTONo}', |
| | | '{oSub.HERPInterID}','{oSub.HERPEntryID}', |
| | | '{oSub.HSEQ}','{oSub.HRECEIVEDEPTID}','{oSub.HSUPPLIERLOT}','{oSub.HBOMID}','{oSub.HSTOCKUNITID}','{oSub.HBASEUNITID}','{oSub.HBFLOWID}','{oSub.HGIVEAWAY}','{oSub.HROWTYPE}','{oSub.HBASEUNITQTY}','{oSub.HSTOCKBASEQTY}', |
| | | '{oSub.HREQTRACENO}','{oSub.HTAXNETPRICE}','{oSub.HPRICECOEFFICIENT}','{oSub.HTAXCOMBINATION}','{oSub.HPRICEUNITID}','{oSub.HPRICELISTENTRY}','{oSub.HPAYORGID}','{oSub.HSETTLEMODEID}','{oSub.HSETTLECURRID}', |
| | | '{oSub.HEXCHANGETYPEID}','{oSub.HPAYCONDITIONID}','{oSub.HEXCHANGERATE}','{oSub.HLOCALCURRID}','{oSub.HISINCLUDEDTAX}','{oSub.HISPRICEEXCLUDETAX}','{oSub.HTAXRATEID}','{oSub.HCOSTPERCENT}','{oSub.HCOSTAMOUNT}', |
| | | '{oSub.HVAT}','{oSub.HSELLERWITHHOLDING}','{oSub.HBUYERWITHHOLDING}','{oSub.HMATERIALDESC}')"; |
| | | oCN.RunProc(sql); |
| | | } |
| | | oCN.Commit(); |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "åæ®ä¿åæåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | /// <summary> |
| | | ///å é¤åè½ |
| | |
| | | /// </summary> |
| | | [Route("Sc_PPBomBill/list")] |
| | | [HttpGet] |
| | | public object list(string sWhere,string user) |
| | | public object list(string sWhere, string user) |
| | | { |
| | | try |
| | | { |
| | |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_IF_PPBomBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc "; |
| | | string sql = sql1 + sWhere + " order by hmainid desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_PPBomBillList"); |
| | | } |
| | | |
| | |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | #region çäº§ç¨ææ¸
å å®¡æ ¸/åå®¡æ ¸ |
| | | [Route("Sc_PPBomBill/DeOrAuditBill")] |
| | | [HttpGet] |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ®ä¸åå¨,åå :"+DBUtility.ClsPub.sExeReturnInfo; |
| | | objJsonResult.Message = "åæ®ä¸åå¨,åå :" + DBUtility.ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | catch (Exception e) |
| | | { |
| | | sReturn = e.Message; |
| | | throw(e); |
| | | throw (e); |
| | | } |
| | | } |
| | | //åå®¡æ ¸ |
| | |
| | | |
| | | DateTime dt = DateTime.Now; |
| | | |
| | | long HQtyMust = DetailColl2[0].HQtyMust == null ? 0 : DetailColl2[0].HQtyMust; //åºåæ°é |
| | | decimal HQtyMust = DetailColl2[0].HQtyMust == null ? 0 : DetailColl2[0].HQtyMust; //åºåæ°é |
| | | double HNumerator = DetailColl2[0].HNumerator == null ? 0 : DetailColl2[0].HNumerator; //åå |
| | | double HDenominator = DetailColl2[0].HDenominator == null ? 0 : DetailColl2[0].HDenominator; //忝 |
| | | double HQtyScrap = DetailColl2[0].HQtyScrap == null ? 0 : DetailColl2[0].HQtyScrap; //æèç |
| | |
| | | { |
| | | NewHEntryID = ClsPub.isLong(Cs.Tables[0].Rows[0]["HEntryID"].ToString()); |
| | | NewHEntryID += 1; |
| | | } |
| | | } |
| | | |
| | | |
| | | oCN.RunProc($@"Insert into Sc_PPBomBillSub |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | [Route("Sc_PPBomBill/Sc_PPBomBillSaveApi")] |
| | | [HttpPost] |
| | | public object Sc_PPBomBillSaveApi([FromBody] JObject sMainSub) |
| | | { |
| | | try |
| | | { |
| | | var model = sMainSub["model"].ToString(); |
| | | var entry = sMainSub["model"]["HENTRY"].ToString(); |
| | | |
| | | model = "[" + model.ToString() + "]"; |
| | | List<ClsSc_PPBomBillMain> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsSc_PPBomBillMain>>(model); |
| | | List<ClsSc_PPBomBillSub> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsSc_PPBomBillSub>>(entry); |
| | | string sql = string.Empty; |
| | | oCN.BeginTran(); |
| | | sql = $"delete Sc_PPBomBillMain where HinterID = {mainList[0].HInterID}"; |
| | | oCN.RunProc(sql); |
| | | sql = $"delete Sc_PPBomBillSub where HinterID = {mainList[0].HInterID}"; |
| | | oCN.RunProc(sql); |
| | | //主表 |
| | | oCN.RunProc(@"Insert Into Sc_PPBomBillMain |
| | | (HInterID,HYear,HPeriod,HBillType,HBillSubType,HDate,HBillNo,HBillStatus,HICMOInterID |
| | | ,HICMOEntryID,HMaterID,HUnitID,HQty,HDeptID,HMaker,HMakeDate,HChecker,HCheckDate |
| | | ,HSeOrderBillNo,HSeOrderInterID,HSeOrderEntryID,HPRDORGID,HENTRUSTORGID,HPARENTOWNERID |
| | | ,HPARENTOWNERTYPEID,HERPInterID,HERPBillType,HSeOrderEntrySEQ,HICMOEntrySEQ,HREQSRC) |
| | | values(" + mainList[0].HInterID + "," + DateTime.Now.Year + "," + DateTime.Now.Month + ",'" + 3720 + "','" + |
| | | mainList[0].HBillSubType + "','" + mainList[0].HDate + "','" + mainList[0].HBillNo + "','" + mainList[0].HBillStatus + "'," + mainList[0].HICMOInterID + |
| | | "," + mainList[0].HICMOEntryID + ",'" + mainList[0].HMaterID + "'," + mainList[0].HUnitID + "," + mainList[0].HQty + "," + mainList[0].HDeptID + |
| | | ",'" + mainList[0].HMaker + "','" + mainList[0].HMakeDate + "','" + mainList[0].HChecker + "','" + mainList[0].HCheckDate + "','" + mainList[0].HSeOrderBillNo + "'," + mainList[0].HSeOrderInterID + "," + mainList[0].HSeOrderEntryID + "," + mainList[0].HPRDORGID + "," + mainList[0].HENTRUSTORGID + "," + mainList[0].HPARENTOWNERID + ",'" + |
| | | mainList[0].HPARENTOWNERTYPEID + "'," + mainList[0].HERPInterID + ",'" + mainList[0].HERPBillType + "'," + mainList[0].HSeOrderEntrySEQ + "," + mainList[0].HICMOEntrySEQ + ",'" + mainList[0].HREQSRC + "')"); |
| | | //ä¿å主表 |
| | | foreach (var oSub in subList) |
| | | { |
| | | oCN.RunProc($@"Insert into Sc_PPBomBillSub |
| | | (HInterID,HEntryID,HMaterID,HMaterNumber,HUnitID,HUnitNumber,HSPID,HQty,HQtyMust,HWHID,HRemark |
| | | ,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HICMOInterID,HICMOEntryID,HICMOBillNo |
| | | ,HCHILDSUPPLYORGID,HSUPPLYORGID,HENTRUSTPICKORGID,HSRCTRANSORGID,HGROUPBYOWNERID,HOWNERID,HOWNERTYPEID |
| | | ,HRelationQty,HMoveStockQty,HAuxPropID,HBatchNO,HMTONo,HQtyScrap,HERPInterID,HERPEntryID |
| | | ,HBackRelationQty,HNumerator,HDenominator,HBASEUNITID,HProcessID,HICMOENTRYSEQ,HPROJECTNO |
| | | ,HOPERID,HSEQ,HSTOCKSTATUSID,HLOT,HOPTQUEUE,HRESERVETYPE,HSelPickedQty,HSELPRCDRETURNQTY) |
| | | values('{oSub.HInterID}','{oSub.HEntryID}','{oSub.HMaterID}','{oSub.HMaterNumber}','{oSub.HUnitID}','{oSub.HUnitNumber}','{oSub.HSPID}','{oSub.HQty}' |
| | | ,'{oSub.HQtyMust}','{oSub.HWHID}','{oSub.HRemark}','{oSub.HSourceInterID}','{oSub.HSourceEntryID}','{oSub.HSourceBillNo}','{oSub.HSourceBillType}','{oSub.HICMOInterID}','{oSub.HICMOEntryID}','{oSub.HICMOBillNo}','{oSub.HCHILDSUPPLYORGID}','{oSub.HSUPPLYORGID}','{oSub.HENTRUSTPICKORGID}','{oSub.HSRCTRANSORGID}','{oSub.HGROUPBYOWNERID}','{oSub.HOWNERID}','{oSub.HOWNERTYPEID}','{oSub.HRelationQty}','{oSub.HMoveStockQty}','{oSub.HAuxPropID}','{oSub.HBatchNO}','{oSub.HMTONo}','{oSub.HQtyScrap}','{oSub.HERPInterID}','{oSub.HERPEntryID}','{oSub.HBackRelationQty}','{oSub.HNumerator}','{oSub.HDenominator}','{oSub.HBASEUNITID}','{oSub.HProcessID}','{oSub.HICMOENTRYSEQ}','{oSub.HPROJECTNO}','{oSub.HOPERID}','{oSub.HSEQ}','{oSub.HSTOCKSTATUSID}','{oSub.HLOT}','{oSub.HOPTQUEUE}','{oSub.HRESERVETYPE}','{oSub.HSelPickedQty}','{oSub.HSELPRCDRETURNQTY}')"); |
| | | } |
| | | oCN.Commit(); |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "åæ®ä¿åæåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | /// <summary> |
| | |
| | | using System; |
| | | using Newtonsoft.Json; |
| | | using System; |
| | | using System.Collections; |
| | | using System.Collections.Generic; |
| | | using System.ComponentModel; |
| | | using System.Data; |
| | | using System.Linq; |
| | | using System.Reflection; |
| | |
| | | List<T> list = new List<T>(); |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | foreach (DataRow row in ds.Tables[0].Rows) |
| | | foreach (DataRow row in ds.Tables[0].Rows) |
| | | { |
| | | list.Add(row.Put(new T())); |
| | | } |
| | |
| | | } |
| | | return $"update {table} set {strSet} where 1=1 {condition}"; |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | /// <summary> |
| | | /// å°Listè½¬æ¢æDataTable |
| | | /// </summary> |
| | | /// <typeparam name="T"></typeparam> |
| | | /// <param name="data"></param> |
| | | /// <returns></returns> |
| | | public static DataTable ToDataTable<T>(this IList<T> data) |
| | | { |
| | | PropertyDescriptorCollection properties = TypeDescriptor.GetProperties(typeof(T)); |
| | | DataTable dt = new DataTable(); |
| | | for (int i = 0; i < properties.Count; i++) |
| | | { |
| | | PropertyDescriptor property = properties[i]; |
| | | dt.Columns.Add(property.Name, property.PropertyType); |
| | | } |
| | | object[] values = new object[properties.Count]; |
| | | foreach (T item in data) |
| | | { |
| | | for (int i = 0; i < values.Length; i++) |
| | | { |
| | | values[i] = properties[i].GetValue(item); |
| | | } |
| | | dt.Rows.Add(values); |
| | | } |
| | | return dt; |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// å°List转æ¢ä¸ºDataTable |
| | | /// </summary> |
| | | /// <param name="list">è¯·æ±æ°æ®</param> |
| | | /// <returns></returns> |
| | | public static DataTable ListToDataTable<T>(List<T> list) |
| | | { |
| | | //å建ä¸ä¸ªå为"tableName"ç空表 |
| | | DataTable dt = new DataTable("tableName"); |
| | | |
| | | //åå»ºä¼ å
¥å¯¹è±¡åç§°çå |
| | | foreach (var item in list.FirstOrDefault().GetType().GetProperties()) |
| | | { |
| | | dt.Columns.Add(item.Name); |
| | | } |
| | | //循ç¯åå¨ |
| | | foreach (var item in list) |
| | | { |
| | | //æ°å è¡ |
| | | DataRow value = dt.NewRow(); |
| | | //æ ¹æ®DataTableä¸çå¼ï¼è¿è¡å¯¹åºçèµå¼ |
| | | foreach (DataColumn dtColumn in dt.Columns) |
| | | { |
| | | int i = dt.Columns.IndexOf(dtColumn); |
| | | //åºå
å
ç´ ï¼ç´æ¥å¤å¶ï¼å¯¹è±¡ç±»åçï¼è¿è¡åºåå |
| | | if (value.GetType().IsPrimitive) |
| | | { |
| | | value[i] = item.GetType().GetProperty(dtColumn.ColumnName).GetValue(item); |
| | | } |
| | | else |
| | | { |
| | | value[i] = JsonConvert.SerializeObject(item.GetType().GetProperty(dtColumn.ColumnName).GetValue(item)); |
| | | } |
| | | } |
| | | dt.Rows.Add(value); |
| | | } |
| | | return dt; |
| | | } |
| | | |
| | | } |
| | | |
| | | } |
| | |
| | | public long HParentID { get; set; } |
| | | public string HRemark { get; set; } |
| | | public string HShortNumber { get; set; } |
| | | public bool HStopflag { get; set; } |
| | | public bool HStopFlag { get; set; } |
| | | public string HUseFlag { get; set; } |
| | | public Int64 HEmpID { get; set; } |
| | | public string HAddress { get; set; } |
| | | public string HPhone { get; set; } |
| | | public bool HIsStockMgr { get; set; } |
| | | public Int64 HSPGroupID { get; set; } |
| | | public string HBarCode { get; set; } |
| | | public Int64 HUSEORGID { get; set; } |
| | |
| | | public DateTime HNoonbreakEnd { get; set; } |
| | | public DateTime HNightbreakBegin { get; set; } |
| | | public DateTime HNightbreakEnd { get; set; } |
| | | public DateTime HNoonbreakBegin2 { get; set; } |
| | | public DateTime HNoonbreakEnd2 { get; set; } |
| | | public DateTime HNightbreakBegin2 { get; set; } |
| | | public DateTime HNightbreakEnd2 { get; set; } |
| | | } |
| | | } |
| | |
| | | <IISExpressWindowsAuthentication /> |
| | | <IISExpressUseClassicPipelineMode /> |
| | | <UseGlobalApplicationHostFile /> |
| | | <ProjectView>ShowAllFiles</ProjectView> |
| | | <ProjectView>ProjectFiles</ProjectView> |
| | | <Controller_SelectedScaffolderID>MvcControllerEmptyScaffolder</Controller_SelectedScaffolderID> |
| | | <Controller_SelectedScaffolderCategoryPath>root/Common/MVC/Controller</Controller_SelectedScaffolderCategoryPath> |
| | | </PropertyGroup> |