/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from TS_DEPT ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 50)
};
parameters[0].Value = C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ModTS_USER_FUN_PCI model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TS_USER_FUN_PCI set ");
strSql.Append("C_ID=:C_ID,");
strSql.Append("C_MODULE_ID=:C_MODULE_ID,");
strSql.Append("C_USER_ID=:C_USER_ID,");
strSql.Append("C_FUNCTION_TYPE=:C_FUNCTION_TYPE,");
strSql.Append("D_MOD_DT=:D_MOD_DT");
strSql.Append(" where ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 50),
new OracleParameter(":C_MODULE_ID", OracleDbType.Varchar2, 20),
new OracleParameter(":C_USER_ID", OracleDbType.Varchar2, 20),
new OracleParameter(":C_FUNCTION_TYPE", OracleDbType.Varchar2, 5),
new OracleParameter(":D_MOD_DT", OracleDbType.Date)
};
parameters[0].Value = model.C_ID;
parameters[1].Value = model.C_MODULE_ID;
parameters[2].Value = model.C_USER_ID;
parameters[3].Value = model.C_FUNCTION_TYPE;
parameters[4].Value = model.D_MOD_DT;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ModTS_USER model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TS_USER set ");
strSql.Append("C_NAME=:C_NAME,");
strSql.Append("C_ACCOUNT=:C_ACCOUNT,");
strSql.Append("C_PASSWORD=:C_PASSWORD,");
strSql.Append("C_EMAIL=:C_EMAIL,");
strSql.Append("C_MOBILE=:C_MOBILE,");
strSql.Append("N_STATUS=:N_STATUS,");
strSql.Append("N_TYPE=:N_TYPE,");
strSql.Append("C_DESC=:C_DESC,");
strSql.Append("D_LASTLOGINTIME=:D_LASTLOGINTIME,");
strSql.Append("C_EMP_ID=:C_EMP_ID,");
strSql.Append("C_EMP_NAME=:C_EMP_NAME,");
strSql.Append("D_MOD_DT=:D_MOD_DT,");
strSql.Append("C_MOBILE2=:C_MOBILE2,");
strSql.Append("C_PHONE=:C_PHONE,");
strSql.Append("C_SHORTNAME=:C_SHORTNAME");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_NAME", OracleDbType.Varchar2, 200),
new OracleParameter(":C_ACCOUNT", OracleDbType.Varchar2, 50),
new OracleParameter(":C_PASSWORD", OracleDbType.Varchar2, 50),
new OracleParameter(":C_EMAIL", OracleDbType.Varchar2, 50),
new OracleParameter(":C_MOBILE", OracleDbType.Varchar2, 50),
new OracleParameter(":N_STATUS", OracleDbType.Int16, 1),
new OracleParameter(":N_TYPE", OracleDbType.Int16, 1),
new OracleParameter(":C_DESC", OracleDbType.Varchar2, 50),
new OracleParameter(":D_LASTLOGINTIME", OracleDbType.Date),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 50),
new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 20),
new OracleParameter(":D_MOD_DT", OracleDbType.Date),
new OracleParameter(":C_MOBILE2", OracleDbType.Varchar2, 50),
new OracleParameter(":C_PHONE", OracleDbType.Varchar2, 50),
new OracleParameter(":C_SHORTNAME", OracleDbType.Varchar2, 200),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 50)
};
parameters[0].Value = model.C_NAME;
parameters[1].Value = model.C_ACCOUNT;
parameters[2].Value = model.C_PASSWORD;
parameters[3].Value = model.C_EMAIL;
parameters[4].Value = model.C_MOBILE;
parameters[5].Value = model.N_STATUS;
parameters[6].Value = model.N_TYPE;
parameters[7].Value = model.C_DESC;
parameters[8].Value = model.D_LASTLOGINTIME;
parameters[9].Value = model.C_EMP_ID;
parameters[10].Value = model.C_EMP_NAME;
parameters[11].Value = model.D_MOD_DT;
parameters[12].Value = model.C_MOBILE2;
parameters[13].Value = model.C_PHONE;
parameters[14].Value = model.C_SHORTNAME;
parameters[15].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
