/// <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);
}