private static EntityData ImportSalPayByClient(string ClientCode, string ProjectCode, DataSet dsSrc, StandardEntityDAO dao) { EntityData data2; try { DataTable table = dsSrc.Tables["account"]; DataTable table2 = dsSrc.Tables["SalPayPlan"]; DataTable table3 = dsSrc.Tables["SalPayRela"]; dao.EntityName = "SalPay"; EntityData entitydata = new EntityData("SalPay"); string[] Params = new string[] { "@ClientCode" }; object[] values = new object[] { ClientCode }; dao.FillEntity(SqlManager.GetSqlStruct("SalPay", "SelectByClient").SqlString, Params, values, entitydata, "SalPay"); if (entitydata.HasRecord()) { dao.DeleteAllRow(entitydata); dao.DeleteEntity(entitydata); } for (int i = 0; i < table.Rows.Count; i++) { DataRow row = entitydata.CurrentTable.NewRow(); DataRow row2 = table.Rows[i]; row["ClientCode"] = ClientCode; row["ProjectCode"] = ProjectCode; row["PayCode"] = row2["account_code"]; row["AccountCode"] = row2["account_code"]; row["PayDate"] = row2["account_date"]; row["PayMoney"] = row2["account_price"]; row["PayType"] = row2["account_type"]; row["Remark"] = row2["remark"]; row["CheckDate"] = row2["check_date"]; row["CheckMan"] = row2["check_man"]; string text = ""; DataRow[] rowArray = table3.Select("account_code = '" + row2["account_code"].ToString() + "'"); if (rowArray.Length > 0) { string text2 = rowArray[0]["plan_code"].ToString(); if (text2 != "") { DataRow[] rowArray2 = table2.Select("pay_plan_code = '" + text2 + "'"); if (rowArray2.Length > 0) { text = rowArray2[0]["contract_code"].ToString(); } } } row["ContractCode"] = text; entitydata.AddNewRecord(row); dao.InsertEntity(entitydata); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetStandard_ClaimsExpressionsByCode(string code, StandardEntityDAO dao) { EntityData data2; try { EntityData entitydata = new EntityData("Standard_ClaimsExpressions"); dao.FillEntity(SqlManager.GetSqlStruct("ClaimsExpressions", "Select").GetSqlStringWithOrder(), "@ClaimsExpressionsCode", code, entitydata, "ClaimsExpressions"); dao.FillEntity(SqlManager.GetSqlStruct("ClaimsExpressionsDetail", "SelectByClaimsExpressionsCode").SqlString, "@ClaimsExpressionsCode", code, entitydata, "ClaimsExpressionsDetail"); data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
private static EntityData ImportSalContractByClient(string ClientCode, string ProjectCode, DataSet dsSrc, StandardEntityDAO dao) { EntityData data2; try { DataTable table = dsSrc.Tables["Contract"]; dao.EntityName = "SalContract"; EntityData entitydata = new EntityData("SalContract"); string[] Params = new string[] { "@ClientCode" }; object[] values = new object[] { ClientCode }; dao.FillEntity(SqlManager.GetSqlStruct("SalContract", "SelectByClient").SqlString, Params, values, entitydata, "SalContract"); if (entitydata.HasRecord()) { dao.DeleteAllRow(entitydata); dao.DeleteEntity(entitydata); } for (int i = 0; i < table.Rows.Count; i++) { DataRow row = entitydata.CurrentTable.NewRow(); DataRow row2 = table.Rows[i]; string contractCode = row2["contract_code"].ToString(); row["ProjectCode"] = ProjectCode; row["ContractCode"] = contractCode; row["ContractID"] = row2["contract_id"]; row["ClientCode"] = row2["client_code"]; row["ClientName"] = row2["client_name"]; row["RoomCode"] = row2["room_code"]; row["ContractDate"] = row2["contract_date"]; row["TotalPrice"] = row2["total_price"]; row["FactPrice"] = row2["fact_price"]; row["UnitPrice"] = row2["unit_price"]; //row["Jiesuan"] = row2["jiesuan"]; // row["BofangCode"] = row2["bofang_code"]; row["ChamberName"] = row2["chamber"]; row["BuildDim"] = row2["build_dim"]; row["RoomDim"] = row2["room_dim"]; row["Room"] = row2["room"]; row["BuildingName"] = row2["build_name"]; //row["JiesuanDate"] = row2["jiesuan_date"]; string suplCodeByName = GetSuplCodeByName(GetSuplNameByContract(row["ContractID"].ToString(), 4), ProjectCode); row["SuplCode"] = suplCodeByName; string roomCode = ProductRule.GetRoomCodeByChamberRoomName(ConvertRule.ToString(row["ChamberName"]), ConvertRule.ToString(row["Room"]), ProjectCode); row["RoomCode"] = roomCode; UpdateRoomSalState(roomCode, contractCode); entitydata.AddNewRecord(row); dao.InsertEntity(entitydata); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetStandard_ConstructProgressByCode(string code) { EntityData data2; try { EntityData entitydata = new EntityData("Standard_ConstructProgress"); using (StandardEntityDAO ydao = new StandardEntityDAO("Standard_ConstructProgress")) { ydao.FillEntity(SqlManager.GetSqlStruct("ConstructProgress", "Select").SqlString, "@ProgressCode", code, entitydata, "ConstructProgress"); ydao.FillEntity(SqlManager.GetSqlStruct("ConstructProgressRisk", "SelectByProgressCode").SqlString, "@ProgressCode", code, entitydata, "ConstructProgressRisk"); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetStandard_ResourceByCode(string code) { EntityData data2; try { EntityData entitydata = new EntityData("Standard_Resource"); using (StandardEntityDAO ydao = new StandardEntityDAO("Standard_Resource")) { ydao.FillEntity(SqlManager.GetSqlStruct("Resource", "Select").SqlString, "@ResourceCode", code, entitydata, "Resource"); ydao.FillEntity(SqlManager.GetSqlStruct("AccessRange", "SelectByResourceCode").SqlString, "@ResourceCode", code, entitydata, "AccessRange"); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetStandard_DocumentByCode(string code) { EntityData data2; try { EntityData entitydata = new EntityData("Standard_Document"); using (StandardEntityDAO ydao = new StandardEntityDAO("Standard_Document")) { ydao.FillEntity(SqlManager.GetSqlStruct("Document", "Select").SqlString, "@DocumentCode", code, entitydata, "Document"); ydao.FillEntity(SqlManager.GetSqlStruct("DocumentConfig", "SelectByDocumentCode").SqlString, "@DocumentCode", code, entitydata, "DocumentConfig"); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetStandard_NoticeByCode(string code) { EntityData data2; try { EntityData entitydata = new EntityData("Standard_Notice"); using (StandardEntityDAO ydao = new StandardEntityDAO("Standard_Notice")) { ydao.FillEntity(SqlManager.GetSqlStruct("Notice", "Select").SqlString, "@NoticeCode", code, entitydata, "Notice"); ydao.FillEntity(SqlManager.GetSqlStruct("NoticeUser", "SelectByNoticeCode").GetSqlStringWithOrder(), "@NoticeCode", code, entitydata, "NoticeUser"); ydao.FillEntity(SqlManager.GetSqlStruct("NoticeAttachMent", "SelectByNoticeCode").GetSqlStringWithOrder(), "@NoticeCode", code, entitydata, "NoticeAttachMent"); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetStandard_SalContractByCode(string code) { EntityData data2; try { EntityData entitydata = new EntityData("Standard_SalContract"); using (StandardEntityDAO ydao = new StandardEntityDAO("Standard_SalContract")) { ydao.FillEntity(SqlManager.GetSqlStruct("SalContract", "Select").SqlString, "@ContractCode", code, entitydata, "SalContract"); ydao.FillEntity(SqlManager.GetSqlStruct("SalPay", "SelectByContract").GetSqlStringWithOrder(), "@ContractCode", code, entitydata, "SalPay"); ydao.FillEntity(SqlManager.GetSqlStruct("SalPayPlan", "SelectByContract").GetSqlStringWithOrder(), "@ContractCode", code, entitydata, "SalPayPlan"); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
public static EntityData GetStandard_SupplierByCode(string code) { EntityData data2; try { EntityData entitydata = new EntityData("Standard_Supplier"); using (StandardEntityDAO ydao = new StandardEntityDAO("Standard_Supplier")) { ydao.FillEntity(SqlManager.GetSqlStruct("Supplier", "Select").SqlString, "@SupplierCode", code, entitydata, "Supplier"); ydao.FillEntity(SqlManager.GetSqlStruct("SupplierOpinion", "SelectBySupplierCode").SqlString, "@SupplierCode", code, entitydata, "SupplierOpinion"); ydao.FillEntity(SqlManager.GetSqlStruct("SupplierSubjectSet", "SelectBySupplierCode").SqlString, "@SupplierCode", code, entitydata, "SupplierSubjectSet"); ydao.FillEntity(SqlManager.GetSqlStruct("ContractBiddingSupplier", "SelectBySupplierCode").SqlString, "@SupplierCode", code, entitydata, "ContractBiddingSupplier"); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
private void ImportSalPay(string[] m_strSub, string ContractCode, string ProjectCode, StandardEntityDAO dao) { try { dao.EntityName = "SalPay"; EntityData entity = new EntityData("SalPay"); string[] os = { "@ContractCode" }; object[] ob = { ContractCode }; dao.FillEntity(SqlManager.GetSqlStruct("SalPay", "SelectByContract").SqlString, os, ob, entity, "SalPay"); if (entity.HasRecord()) { dao.DeleteAllRow(entity); dao.DeleteEntity(entity); } DataRow dr; dr = entity.CurrentTable.NewRow(); dr["ProjectCode"] = ProjectCode; dr["ContractCode"] = ContractCode; dr["ContractID"] = m_strSub[2]; dr["PayCode"] = m_strSub[2]; dr["AccountCode"] = m_strSub[2]; try { dr["PayMoney"] = m_strSub[9]; } catch { dr["PayMoney"] = 0; } entity.AddNewRecord(dr); dao.InsertEntity(entity); entity.Dispose(); } catch (Exception ex) { throw ex; } }
private static EntityData ImportSalPayPlanByClient(string ClientCode, string ProjectCode, DataSet dsSrc, StandardEntityDAO dao) { EntityData data2; try { DataTable table = dsSrc.Tables["SalPayPlan"]; dao.EntityName = "SalPayPlan"; EntityData entitydata = new EntityData("SalPayPlan"); string[] Params = new string[] { "@ClientCode" }; object[] values = new object[] { ClientCode }; dao.FillEntity(SqlManager.GetSqlStruct("SalPayPlan", "SelectByClient").SqlString, Params, values, entitydata, "SalPayPlan"); if (entitydata.HasRecord()) { dao.DeleteAllRow(entitydata); dao.DeleteEntity(entitydata); } for (int i = 0; i < table.Rows.Count; i++) { DataRow row = entitydata.CurrentTable.NewRow(); DataRow row2 = table.Rows[i]; row["PayPlanCode"] = row2["pay_plan_code"]; row["ClientCode"] = ClientCode; row["ProjectCode"] = ProjectCode; row["ContractCode"] = row2["contract_code"]; row["PayMode"] = row2["pay_mode"]; row["Prompt"] = row2["Prompt"]; row["PlanMoney"] = row2["price"]; row["ItemName"] = row2["item_name"]; entitydata.AddNewRecord(row); dao.InsertEntity(entitydata); } data2 = entitydata; } catch (Exception exception) { throw exception; } return(data2); }
public static void PBSTypeCopyByProject(string srcProjectCode, string dstProjectCode) { Exception exception; try { using (StandardEntityDAO ydao = new StandardEntityDAO("PBSType")) { ydao.BeginTrans(); try { EntityData entitydata = new EntityData("PBSType"); ydao.FillEntity(SqlManager.GetSqlStruct("PBSType", "SelectByProjectCode").SqlString, "@ProjectCode", dstProjectCode, entitydata, "PBSType"); ydao.DeleteAllRow(entitydata); ydao.DeleteEntity(entitydata); DataTable table = new DataTable(); table.Columns.Add("OldPBSTypeCode", typeof(string)); table.Columns.Add("NewPBSTypeCode", typeof(string)); EntityData data2 = new EntityData("PBSType"); ydao.FillEntity(SqlManager.GetSqlStruct("PBSType", "SelectByProjectCode").SqlString, "@ProjectCode", srcProjectCode, data2, "PBSType"); int num = 1; for (DataRow[] rowArray = data2.CurrentTable.Select("deep=" + num.ToString()); rowArray.Length > 0; rowArray = data2.CurrentTable.Select("deep=" + num.ToString())) { foreach (DataRow row in rowArray) { DataRow row2 = entitydata.CurrentTable.NewRow(); string newSysCode = SystemManageDAO.GetNewSysCode("PBSTypeCode"); row2["PBSTypeCode"] = newSysCode; row2["ProjectCode"] = dstProjectCode; row2["PBSTypeName"] = ConvertRule.ToString(row["PBSTypeName"]); row2["Description"] = ConvertRule.ToString(row["Description"]); row2["Deep"] = ConvertRule.ToInt(row["Deep"]); row2["SortID"] = ConvertRule.ToInt(row["SortID"]); DataRow row3 = table.NewRow(); row3["OldPBSTypeCode"] = ConvertRule.ToString(row["PBSTypeCode"]); row3["NewPBSTypeCode"] = newSysCode; table.Rows.Add(row3); string text2 = ConvertRule.ToString(row["ParentCode"]); if (text2 != "") { DataRow[] rowArray2 = table.Select("OldPBSTypeCode='" + text2 + "'"); if (rowArray2.Length > 0) { text2 = ConvertRule.ToString(rowArray2[0]["NewPBSTypeCode"]); } } string text3 = ""; if (text2 != "") { DataRow[] rowArray3 = entitydata.CurrentTable.Select("PBSTypeCode='" + text2 + "'"); if (rowArray3.Length > 0) { text3 = ConvertRule.ToString(rowArray3[0]["FullID"]); } } string text4 = newSysCode; if (text3 != "") { text4 = text3 + "-" + text4; } row2["ParentCode"] = text2; row2["FullID"] = text4; entitydata.CurrentTable.Rows.Add(row2); } num++; } ydao.InsertEntity(entitydata); ydao.CommitTrans(); data2.Dispose(); entitydata.Dispose(); } catch (Exception exception1) { exception = exception1; try { ydao.RollBackTrans(); } catch { } throw exception; } } } catch (Exception exception2) { exception = exception2; throw exception; } }