public static Guid TransferSetId(string old) { try { Guid result = Guid.Empty; RelationSqlServerUtility rsql = new RelationSqlServerUtility(); string strsql = "select distinct new from Rset where old='{0}'"; DataSet ds = rsql.ExecuteSqlDataSet(string.Format(strsql, old)); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Columns.Count > 0) { result = new Guid(ds.Tables[0].Rows[0][0].ToString()); } return result; } catch (Exception ex) { throw ex; } }
/// <summary> /// 而且要添加ExpertFirld /// </summary> public static void TransferUserFieldRelation(string old, Guid userid) { Guid result = Guid.Empty; RelationSqlServerUtility rsql = new RelationSqlServerUtility(); DataSet ds = rsql.ExecuteSqlDataSet(string.Format("select new from RFieldForUserNLab where old='{0}'", old)); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { result = new Guid(ds.Tables[0].Rows[0][0].ToString()); } CY.CSTS.Core.Business.ExpertField expertfield = new CY.CSTS.Core.Business.ExpertField(); expertfield.FieldID = result; expertfield.ExpertID = userid; expertfield.Save(); }
protected void import_Click(object sender, EventArgs e) { CY.Utility.DBUtility.ImportSqlServerUtility isql = new CY.Utility.DBUtility.ImportSqlServerUtility(); string strsql = "select * from PERSONNEL"; DataSet ds = isql.ExecuteSqlDataSet(strsql); RelationSqlServerUtility rsql = new RelationSqlServerUtility(); string Rsql = "select * from RUser"; DataSet dsR = rsql.ExecuteSqlDataSet(Rsql); Rsql = "select * from RLab"; DataSet dsRLab = rsql.ExecuteSqlDataSet(Rsql); //List<CY.CSTS.Core.Business.Lab> listLab = CY.CSTS.Core.Business.Lab.GetAllLab() as List<CY.CSTS.Core.Business.Lab>; if (dsRLab != null && dsRLab.Tables.Count > 0 && dsRLab.Tables[0].Rows.Count > 0 && dsRLab.Tables[0].Columns.Count > 0) { for (int i = 0; i < dsRLab.Tables[0].Rows.Count; i++) { strsql = "select * from LABORATORY where LABID = " + dsRLab.Tables[0].Rows[i][0].ToString(); DataSet dsLab = isql.ExecuteSqlDataSet(strsql); if (dsLab != null && dsLab.Tables.Count > 0 && dsLab.Tables[0].Rows.Count > 0 && dsLab.Tables[0].Columns.Count > 0) { string strLeadUserID = "0"; string strLinkUserID = "0"; if (dsLab.Tables[0].Rows[0]["LEAD"] != null) { strLeadUserID = dsLab.Tables[0].Rows[0]["LEAD"].ToString(); } if (dsLab.Tables[0].Rows[0]["LINKMAN"] != null) { strLinkUserID = dsLab.Tables[0].Rows[0]["LINKMAN"].ToString(); } if (strLeadUserID == "") { strLeadUserID = "0"; } if (strLinkUserID == "") { strLinkUserID = "0"; } strsql = "select * from PERSONNEL where PERSONNELID = " + strLeadUserID; DataSet dsLabLeadP = isql.ExecuteSqlDataSet(strsql); strsql = "select * from PERSONNEL where PERSONNELID = " + strLinkUserID; DataSet dsLabLinkP = isql.ExecuteSqlDataSet(strsql); string leadName = ""; string linkName = ""; if (dsLabLeadP != null && dsLabLeadP.Tables.Count > 0 && dsLabLeadP.Tables[0].Rows.Count > 0 && dsLabLeadP.Tables[0].Columns.Count > 0) { leadName = dsLabLeadP.Tables[0].Rows[0]["NAME"].ToString(); } if (dsLabLinkP != null && dsLabLinkP.Tables.Count > 0 && dsLabLinkP.Tables[0].Rows.Count > 0 && dsLabLinkP.Tables[0].Columns.Count > 0) { linkName = dsLabLinkP.Tables[0].Rows[0]["NAME"].ToString(); } if (CY.Utility.Common.StringHelper.IsGuid(dsRLab.Tables[0].Rows[i][1].ToString())) { Guid LabId = new Guid(dsRLab.Tables[0].Rows[i][1].ToString()); CY.CSTS.Core.Business.Lab lab = CY.CSTS.Core.Business.Lab.Load(LabId); if (lab != null) { lab.LabPrincipal = leadName; lab.LinkMan = linkName; lab.Save(); } } } } } }
protected void import_Machine_LinkMan_Click(object sender, EventArgs e) { CY.Utility.DBUtility.ImportSqlServerUtility isql = new CY.Utility.DBUtility.ImportSqlServerUtility(); RelationSqlServerUtility rsql = new RelationSqlServerUtility(); string Rsql = "select * from RSet"; DataSet dsRSet = rsql.ExecuteSqlDataSet(Rsql); if (dsRSet != null && dsRSet.Tables.Count > 0 && dsRSet.Tables[0].Rows.Count > 0 && dsRSet.Tables[0].Columns.Count > 0) { for (int i = 0; i < dsRSet.Tables[0].Rows.Count; i++) { string strsql = "select * from MACHINESET where SETID = " + dsRSet.Tables[0].Rows[i][0].ToString(); DataSet dsSet = isql.ExecuteSqlDataSet(strsql); string strLinkID = "0"; if (dsSet != null && dsSet.Tables.Count > 0 && dsSet.Tables[0].Rows.Count > 0 && dsSet.Tables[0].Columns.Count > 0) { strLinkID = dsSet.Tables[0].Rows[0]["LINKMAN"].ToString(); } if (strLinkID == "") { strLinkID = "0"; } strsql = "select * from PERSONNEL where PERSONNELID = " + strLinkID; DataSet dsLabLinkP = isql.ExecuteSqlDataSet(strsql); string linkName = ""; if (dsLabLinkP != null && dsLabLinkP.Tables.Count > 0 && dsLabLinkP.Tables[0].Rows.Count > 0 && dsLabLinkP.Tables[0].Columns.Count > 0) { linkName = dsLabLinkP.Tables[0].Rows[0]["NAME"].ToString(); } if (CY.Utility.Common.StringHelper.IsGuid(dsRSet.Tables[0].Rows[i][1].ToString())) { Guid SetId = new Guid(dsRSet.Tables[0].Rows[i][1].ToString()); CY.CSTS.Core.Business.MACHINESET set = CY.CSTS.Core.Business.MACHINESET.Load(SetId); if (set != null) { set.LINKMAN = linkName; set.Save(); } } } } }
protected void import_Machine_Click(object sender, EventArgs e) { CY.Utility.DBUtility.ImportSqlServerUtility isql = new CY.Utility.DBUtility.ImportSqlServerUtility(); string strsql = "select * from INSTRUMENT"; DataSet ds = isql.ExecuteSqlDataSet(strsql); RelationSqlServerUtility rsql = new RelationSqlServerUtility(); string Rsql = "select * from RInstrument"; DataSet dsR = rsql.ExecuteSqlDataSet(Rsql); Rsql = "select * from RInstrument"; DataSet dsRLab = rsql.ExecuteSqlDataSet(Rsql); //List<CY.CSTS.Core.Business.INSTRUMENT> listLab = CY.CSTS.Core.Business.INSTRUMENT.GetAllINSTRUMENT() as List<CY.CSTS.Core.Business.INSTRUMENT>; if (dsRLab != null && dsRLab.Tables.Count > 0 && dsRLab.Tables[0].Rows.Count > 0 && dsRLab.Tables[0].Columns.Count > 0) { for (int i = 0; i < dsRLab.Tables[0].Rows.Count; i++) { strsql = "select * from INSTRUMENT where INSTRUMENTID = " + dsRLab.Tables[0].Rows[i][0].ToString(); DataSet dsLab = isql.ExecuteSqlDataSet(strsql); if (dsLab != null && dsLab.Tables.Count > 0 && dsLab.Tables[0].Rows.Count > 0 && dsLab.Tables[0].Columns.Count > 0) { string oldMID = "0"; if (dsLab.Tables[0].Rows[0]["SETID"] != null) { oldMID = dsLab.Tables[0].Rows[0]["SETID"].ToString(); } if (oldMID == "") { oldMID = "0"; } strsql = "select * from RSet where old = " + oldMID; DataSet dsRSet = rsql.ExecuteSqlDataSet(strsql); string strMID = ""; if (dsRSet != null && dsRSet.Tables.Count > 0 && dsRSet.Tables[0].Rows.Count > 0 && dsRSet.Tables[0].Columns.Count > 0) { strMID = dsRSet.Tables[0].Rows[0][1].ToString(); if (CY.Utility.Common.StringHelper.IsGuid(strMID)) { Guid MId = new Guid(strMID); if (CY.CSTS.Core.Business.MACHINESET.Load(MId) != null) { if (CY.Utility.Common.StringHelper.IsGuid(dsRLab.Tables[0].Rows[i][1].ToString())) { Guid IId = new Guid(dsRLab.Tables[0].Rows[i][1].ToString()); CY.CSTS.Core.Business.INSTRUMENT instrument = CY.CSTS.Core.Business.INSTRUMENT.Load(IId); if (instrument != null) { instrument.MachineGroupId = MId; instrument.Save(); } } } } } } } } }
protected void import_MachineMemeber_Click(object sender, EventArgs e) { List<CY.CSTS.Core.Business.INSTRUMENT> listInstrument = CY.CSTS.Core.Business.INSTRUMENT.GetAllINSTRUMENT() as List<CY.CSTS.Core.Business.INSTRUMENT>; CY.Utility.DBUtility.ImportSqlServerUtility isql = new CY.Utility.DBUtility.ImportSqlServerUtility(); RelationSqlServerUtility rsql = new RelationSqlServerUtility(); string Rsql = "select * from RSet"; DataSet dsRSet = rsql.ExecuteSqlDataSet(Rsql); if (dsRSet != null && dsRSet.Tables.Count > 0 && dsRSet.Tables[0].Rows.Count > 0 && dsRSet.Tables[0].Columns.Count > 0) { for (int i = 0; i < dsRSet.Tables[0].Rows.Count; i++) { string strsql = "select * from MACHINESET where SETID = " + dsRSet.Tables[0].Rows[i][0].ToString(); DataSet dsSet = isql.ExecuteSqlDataSet(strsql); string[] strSetManID; string strSetMan = ""; if (dsSet != null && dsSet.Tables.Count > 0 && dsSet.Tables[0].Rows.Count > 0 && dsSet.Tables[0].Columns.Count > 0) { strSetMan = dsSet.Tables[0].Rows[0]["SETMAN"].ToString(); } if (strSetMan == "") { strSetMan = "0"; } if (strSetMan != "0") { strSetManID = strSetMan.Split(','); for (int j = 0; j < strSetManID.Count(); j++) { string strManID = strSetManID[j]; int iTemp = 0; if (strManID != "" && int.TryParse(strManID, out iTemp)) { //try { if (CY.Utility.Common.StringHelper.IsGuid(dsRSet.Tables[0].Rows[i][1].ToString())) { Guid NewSetID = new Guid(dsRSet.Tables[0].Rows[i][1].ToString()); CY.CSTS.Core.Business.MACHINESET newM = CY.CSTS.Core.Business.MACHINESET.Load(NewSetID); int usertype = 0; Guid UintID = new Guid(); if (newM.Unit != null) { if (newM.Unit.IsCooperantUnit == 2) { usertype = 2; } else { usertype = 3; } UintID = newM.Unit.Id; strsql = "select * from PERSONNEL where PERSONNELID = " + strManID; DataSet ds = isql.ExecuteSqlDataSet(strsql); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Columns.Count > 0) { for (int k = 0; k < ds.Tables[0].Rows.Count; k++) { if (ds.Tables[0].Rows[k][4] != null) { CY.CSTS.Core.Business.User user = CY.CSTS.Core.Business.User.GetUserByUserId(ds.Tables[0].Rows[k][4].ToString()); if (user == null) { user = new CY.CSTS.Core.Business.User(); user.UnitID = UintID; user.UserType = usertype; user.Password = "******"; user.UserID = ds.Tables[0].Rows[k][4].ToString(); user.Name = ds.Tables[0].Rows[k][4].ToString(); user.Gender = ds.Tables[0].Rows[k][5].ToString(); user.BirthDate = !string.IsNullOrEmpty(ds.Tables[0].Rows[k][6].ToString()) ? DateTime.Parse(ds.Tables[0].Rows[k][6].ToString()) : DateTime.MinValue; user.EducationID = CY.CSTS.Import.Core.Business.User.TransferEducationId(ds.Tables[0].Rows[k][7].ToString()); user.PostRankID = CY.CSTS.Import.Core.Business.User.TransferTitltId(ds.Tables[0].Rows[k][8].ToString()); user.Specialty = ds.Tables[0].Rows[k][9].ToString(); user.Address = ds.Tables[0].Rows[k][10].ToString(); user.Mailcode = ds.Tables[0].Rows[k][11].ToString(); user.Phone = ds.Tables[0].Rows[k][12].ToString(); user.Fax = ds.Tables[0].Rows[k][13].ToString(); user.Email = ds.Tables[0].Rows[k][14].ToString(); user.Resume = ds.Tables[0].Rows[k][15].ToString(); user.Discourse = ds.Tables[0].Rows[k][20].ToString(); user.Acquire = ds.Tables[0].Rows[k][21].ToString(); user.Status = 2; user.Remark = ds.Tables[0].Rows[k][25].ToString(); user.Save(); } List<CY.CSTS.Core.Business.INSTRUMENT> tempListI = listInstrument.Where(Items => Items.MachineGroupId == newM.Id).ToList(); if (tempListI.Count > 0) { CY.CSTS.Core.Business.MachineGroupMember MMember = new CY.CSTS.Core.Business.MachineGroupMember(); MMember.InstruID = tempListI[0].Id; MMember.UserID = user.Id; MMember.MachineGroupID = newM.Id; MMember.Save(); } } } } } } } //catch (Exception ex) //{ // throw ex; //} } } } } } }
private static Guid TransferDomainId(string old) { Guid result = Guid.Empty; RelationSqlServerUtility rsql = new RelationSqlServerUtility(); if (!string.IsNullOrEmpty(old)) { string strsql = "select distinct new from RField where old='{0}'"; DataSet ds = rsql.ExecuteSqlDataSet(string.Format(strsql, old)); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Columns.Count > 0) { result = new Guid(ds.Tables[0].Rows[0][0].ToString()); } } return result; }
/// <summary> /// OK /// </summary> /// <param name="old"></param> /// <returns></returns> public static Guid TransferTradeId(string old) { try { if (!string.IsNullOrEmpty(old)) { RelationSqlServerUtility rsql = new RelationSqlServerUtility(); string strsql = "Select distinct new from RTrade where old='{0}'"; DataSet ds = rsql.ExecuteSqlDataSet(string.Format(strsql, old)); if (ds != null && ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Columns.Count > 0) { return new Guid(ds.Tables[0].Rows[0][0].ToString()); } else { return Guid.Empty; } } return Guid.Empty; } catch (Exception ex) { throw ex; } }