/// <summary> /// 修改 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Modify(T_BASE_UNITTYPEModel model) { XMLDbHelper.FactoryDbHelper af = new XMLDbHelper.FactoryDbHelper(); DateTime sjc = af.GetDbDatetimestamp(); StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("UPDATE T_BASE_UNITTYPE SET "); sBuilder.Append("LXMC=:LXMC,"); sBuilder.Append("FLXBM=:FLXBM,"); sBuilder.Append("SFSC=:SFSC,"); sBuilder.Append("BL1=:BL1,"); sBuilder.Append("BL2=:BL2,"); sBuilder.Append("BL3=:BL3,"); sBuilder.Append("CJR=:CJR,"); sBuilder.Append("CJSJ=:CJSJ,"); sBuilder.Append("XGR=:XGR,"); sBuilder.Append("XGSJ=:XGSJ,"); sBuilder.Append("SJC=:SJC "); sBuilder.Append("WHERE LXBM=:LXBM "); OracleParameter[] oparams = { new OracleParameter(":LXBM", OracleType.VarChar), new OracleParameter(":LXMC", OracleType.VarChar), new OracleParameter(":SFSC", OracleType.Number), new OracleParameter(":BL1", OracleType.VarChar), new OracleParameter(":BL2", OracleType.VarChar), new OracleParameter(":BL3", OracleType.VarChar), new OracleParameter(":CJR", OracleType.VarChar), new OracleParameter(":CJSJ", OracleType.VarChar), new OracleParameter(":XGR", OracleType.VarChar), new OracleParameter(":XGSJ", OracleType.VarChar), new OracleParameter(":SJC", OracleType.VarChar), new OracleParameter(":FLXBM", OracleType.VarChar) }; oparams[0].Value = model.LXBM; oparams[1].Value = model.LXMC; oparams[2].Value = model.SFSC; oparams[3].Value = model.BL1; oparams[4].Value = model.BL2; oparams[5].Value = model.BL3; oparams[6].Value = model.CJR; oparams[7].Value = model.CJSJ; oparams[8].Value = model.XGR; oparams[9].Value = sjc.ToString("yyyyMMddHHmmss"); //model.XGSJ; oparams[10].Value = sjc.ToString("yyyy-MM-dd HH:mm:ss.ffffff"); //model.SJC oparams[11].Value = model.FLXBM; //model.SJC; int ret = af.ExecuteNonQuery(sBuilder.ToString(), oparams); return(ret); }
/// <summary> /// 更新执行时间 /// </summary> /// <param name="taskId"></param> /// <param name="lastDatetime"></param> /// <returns></returns> public int UpdateTaskLastDateTime(string taskId, string lastDatetime) { string sql = "UPDATE T_D_TASK_MST SET LASTDATETIME=:LASTDATETIME WHERE ID=:ID"; OracleParameter[] oracleParameters = { new OracleParameter(":LASTDATETIME", OracleType.VarChar), new OracleParameter(":ID", OracleType.VarChar) }; oracleParameters[0].Value = lastDatetime; oracleParameters[1].Value = taskId; XMLDbHelper.FactoryDbHelper af = new XMLDbHelper.FactoryDbHelper(); return(af.ExecuteNonQuery(sql, oracleParameters)); }
/// <summary> /// 删除 /// </summary> /// <param name="id"></param> /// <returns></returns> public int Delete(string id) { StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("DELETE FROM T_D_TASK_MST "); sBuilder.Append("WHERE ID=:ID "); OracleParameter[] oparams = { new OracleParameter(":ID", OracleType.VarChar) }; oparams[0].Value = id; XMLDbHelper.FactoryDbHelper af = new XMLDbHelper.FactoryDbHelper(); int ret = af.ExecuteNonQuery(sBuilder.ToString(), oparams); return(ret); }
/// <summary> /// 删除 /// </summary> /// <param name="username"></param> /// <returns></returns> public int Delete(string username) { StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("DELETE FROM T_B_USER "); sBuilder.Append("WHERE USERNAME=:USERNAME "); OracleParameter[] oparams = { new OracleParameter(":USERNAME", OracleType.VarChar) }; oparams[0].Value = username; XMLDbHelper.FactoryDbHelper af = new XMLDbHelper.FactoryDbHelper(); int ret = af.ExecuteNonQuery(sBuilder.ToString(), oparams); return(ret); }
/// <summary> /// 删除 /// </summary> /// <param name="pzbm"></param> /// <returns></returns> public int Delete(string pzbm) { StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("DELETE FROM T_BASE_SJYPZ "); sBuilder.Append("WHERE PZBM=:PZBM "); OracleParameter[] oparams = { new OracleParameter(":PZBM", OracleType.VarChar) }; oparams[0].Value = pzbm; XMLDbHelper.FactoryDbHelper af = new XMLDbHelper.FactoryDbHelper(); int ret = af.ExecuteNonQuery(sBuilder.ToString(), oparams); return(ret); }
/// <summary> /// 新增 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(T_B_USERModel model) { StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("INSERT INTO T_B_USER("); sBuilder.Append("USERNAME,"); sBuilder.Append("PASSWORD,"); sBuilder.Append("XM,"); sBuilder.Append("USERTYPE,"); sBuilder.Append("SFJY,"); sBuilder.Append("BL1,"); sBuilder.Append("BL2,"); sBuilder.Append("BL3"); sBuilder.Append(") VALUES("); sBuilder.Append(":USERNAME,"); sBuilder.Append(":PASSWORD,"); sBuilder.Append(":XM,"); sBuilder.Append(":USERTYPE,"); sBuilder.Append(":SFJY,"); sBuilder.Append(":BL1,"); sBuilder.Append(":BL2,"); sBuilder.Append(":BL3"); sBuilder.Append(")"); OracleParameter[] oparams = { new OracleParameter(":USERNAME", OracleType.VarChar), new OracleParameter(":PASSWORD", OracleType.VarChar), new OracleParameter(":XM", OracleType.VarChar), new OracleParameter(":USERTYPE", OracleType.VarChar), new OracleParameter(":SFJY", OracleType.Number), new OracleParameter(":BL1", OracleType.VarChar), new OracleParameter(":BL2", OracleType.VarChar), new OracleParameter(":BL3", OracleType.VarChar) }; oparams[0].Value = model.USERNAME; oparams[1].Value = model.PASSWORD; oparams[2].Value = model.XM; oparams[3].Value = model.USERTYPE; oparams[4].Value = model.SFJY; oparams[5].Value = model.BL1; oparams[6].Value = model.BL2; oparams[7].Value = model.BL3; XMLDbHelper.FactoryDbHelper af = new XMLDbHelper.FactoryDbHelper(); int ret = af.ExecuteNonQuery(sBuilder.ToString(), oparams); return(ret); }
/// <summary> /// 修改 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Modify(T_BASE_SJYPZModel model) { XMLDbHelper.FactoryDbHelper af = new XMLDbHelper.FactoryDbHelper(); DateTime sjc = af.GetDbDatetimestamp(); StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("UPDATE T_BASE_SJYPZ SET "); sBuilder.Append("PZMC=:PZMC,"); sBuilder.Append("SJIP=:SJIP,"); sBuilder.Append("SJPORT=:SJPORT,"); sBuilder.Append("SJSID=:SJSID,"); sBuilder.Append("SJUSERID=:SJUSERID,"); sBuilder.Append("SJPASSWORD=:SJPASSWORD,"); sBuilder.Append("SFSC=:SFSC,"); sBuilder.Append("BL1=:BL1,"); sBuilder.Append("BL2=:BL2,"); sBuilder.Append("BL3=:BL3,"); sBuilder.Append("CJR=:CJR,"); sBuilder.Append("CJSJ=:CJSJ,"); sBuilder.Append("XGR=:XGR,"); sBuilder.Append("XGSJ=:XGSJ,"); sBuilder.Append("SJC=:SJC "); sBuilder.Append("WHERE PZBM=:PZBM "); OracleParameter[] oparams = { new OracleParameter(":PZBM", OracleType.VarChar), new OracleParameter(":PZMC", OracleType.VarChar), new OracleParameter(":SJIP", OracleType.VarChar), new OracleParameter(":SJPORT", OracleType.VarChar), new OracleParameter(":SJSID", OracleType.VarChar), new OracleParameter(":SJUSERID", OracleType.VarChar), new OracleParameter(":SJPASSWORD", OracleType.VarChar), new OracleParameter(":SFSC", OracleType.Number), new OracleParameter(":BL1", OracleType.VarChar), new OracleParameter(":BL2", OracleType.VarChar), new OracleParameter(":BL3", OracleType.VarChar), new OracleParameter(":CJR", OracleType.VarChar), new OracleParameter(":CJSJ", OracleType.VarChar), new OracleParameter(":XGR", OracleType.VarChar), new OracleParameter(":XGSJ", OracleType.VarChar), new OracleParameter(":SJC", OracleType.VarChar) }; oparams[0].Value = model.PZBM; oparams[1].Value = model.PZMC; oparams[2].Value = model.SJIP; oparams[3].Value = model.SJPORT; oparams[4].Value = model.SJSID; oparams[5].Value = model.SJUSERID; oparams[6].Value = model.SJPASSWORD; oparams[7].Value = model.SFSC; oparams[8].Value = model.BL1; oparams[9].Value = model.BL2; oparams[10].Value = model.BL3; oparams[11].Value = model.CJR; oparams[12].Value = model.CJSJ; oparams[13].Value = model.XGR; oparams[14].Value = sjc.ToString("yyyyMMddHHmmss"); //model.XGSJ; oparams[15].Value = sjc.ToString("yyyy-MM-dd HH:mm:ss.ffffff"); //model.SJC; int ret = af.ExecuteNonQuery(sBuilder.ToString(), oparams); return(ret); }
/// <summary> /// 新增 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(T_BASE_SJYPZModel model) { XMLDbHelper.FactoryDbHelper af = new XMLDbHelper.FactoryDbHelper(); DateTime sjc = af.GetDbDatetimestamp(); StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("INSERT INTO T_BASE_SJYPZ("); sBuilder.Append("PZBM,"); sBuilder.Append("PZMC,"); sBuilder.Append("SJIP,"); sBuilder.Append("SJPORT,"); sBuilder.Append("SJSID,"); sBuilder.Append("SJUSERID,"); sBuilder.Append("SJPASSWORD,"); sBuilder.Append("SFSC,"); sBuilder.Append("BL1,"); sBuilder.Append("BL2,"); sBuilder.Append("BL3,"); sBuilder.Append("CJR,"); sBuilder.Append("CJSJ,"); sBuilder.Append("XGR,"); sBuilder.Append("XGSJ,"); sBuilder.Append("SJC"); sBuilder.Append(") VALUES("); sBuilder.Append(":PZBM,"); sBuilder.Append(":PZMC,"); sBuilder.Append(":SJIP,"); sBuilder.Append(":SJPORT,"); sBuilder.Append(":SJSID,"); sBuilder.Append(":SJUSERID,"); sBuilder.Append(":SJPASSWORD,"); sBuilder.Append(":SFSC,"); sBuilder.Append(":BL1,"); sBuilder.Append(":BL2,"); sBuilder.Append(":BL3,"); sBuilder.Append(":CJR,"); sBuilder.Append(":CJSJ,"); sBuilder.Append(":XGR,"); sBuilder.Append(":XGSJ,"); sBuilder.Append(":SJC"); sBuilder.Append(")"); OracleParameter[] oparams = { new OracleParameter(":PZBM", OracleType.VarChar), new OracleParameter(":PZMC", OracleType.VarChar), new OracleParameter(":SJIP", OracleType.VarChar), new OracleParameter(":SJPORT", OracleType.VarChar), new OracleParameter(":SJSID", OracleType.VarChar), new OracleParameter(":SJUSERID", OracleType.VarChar), new OracleParameter(":SJPASSWORD", OracleType.VarChar), new OracleParameter(":SFSC", OracleType.Number), new OracleParameter(":BL1", OracleType.VarChar), new OracleParameter(":BL2", OracleType.VarChar), new OracleParameter(":BL3", OracleType.VarChar), new OracleParameter(":CJR", OracleType.VarChar), new OracleParameter(":CJSJ", OracleType.VarChar), new OracleParameter(":XGR", OracleType.VarChar), new OracleParameter(":XGSJ", OracleType.VarChar), new OracleParameter(":SJC", OracleType.VarChar) }; oparams[0].Value = af.GetID(T_BASE_PUBLIC.UNITNAMEKEY, "T_BASE_SJYPZ");//model.PZBM; oparams[1].Value = model.PZMC; oparams[2].Value = model.SJIP; oparams[3].Value = model.SJPORT; oparams[4].Value = model.SJSID; oparams[5].Value = model.SJUSERID; oparams[6].Value = model.SJPASSWORD; oparams[7].Value = model.SFSC; oparams[8].Value = model.BL1; oparams[9].Value = model.BL2; oparams[10].Value = model.BL3; oparams[11].Value = model.CJR; oparams[12].Value = sjc.ToString("yyyyMMddHHmmss");//model.CJSJ; oparams[13].Value = model.XGR; oparams[14].Value = model.XGSJ; oparams[15].Value = sjc.ToString("yyyy-MM-dd HH:mm:ss.ffffff");//model.SJC; int ret = af.ExecuteNonQuery(sBuilder.ToString(), oparams); return(ret); }