public void Add(SMZJ.Model.MYFILETEST model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into MYFILETEST(");
builder.Append("商品编号,商品名称,商品小图地址)");
builder.Append(" values (");
builder.Append(":商品编号,:商品名称,:商品小图地址)");
OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":商品编号", OracleType.Number, 4), new OracleParameter(":商品名称", OracleType.VarChar, 0xff), new OracleParameter(":商品小图地址", OracleType.VarChar, 0xff) };
cmdParms[0].Value = model.商品编号;
cmdParms[1].Value = model.商品名称;
cmdParms[2].Value = model.商品小图地址;
DbHelperOra.ExecuteSql(builder.ToString(), cmdParms);
}
public void Add(SMZJ.Model.TB_QUOTA_DETAIL_TMP model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into TB_QUOTA_DETAIL_TMP(");
builder.Append("AUTO_NO,PD_QUOTA_CODE,COMPANY_NAME,FILE_NAME,FILE_SYSNAME,COMPANY_CODE,FILE_TYPE)");
builder.Append(" values (");
builder.Append(":AUTO_NO,:PD_QUOTA_CODE,:COMPANY_NAME,:FILE_NAME,:FILE_SYSNAME,:COMPANY_CODE,:FILE_TYPE)");
OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":AUTO_NO", OracleType.Number, 4), new OracleParameter(":PD_QUOTA_CODE", OracleType.VarChar, 30), new OracleParameter(":COMPANY_NAME", OracleType.VarChar, 50), new OracleParameter(":FILE_NAME", OracleType.VarChar, 30), new OracleParameter(":FILE_SYSNAME", OracleType.VarChar, 50), new OracleParameter(":COMPANY_CODE", OracleType.VarChar, 20), new OracleParameter(":FILE_TYPE", OracleType.VarChar, 20) };
cmdParms[0].Value = model.AUTO_NO;
cmdParms[1].Value = model.PD_QUOTA_CODE;
cmdParms[2].Value = model.COMPANY_NAME;
cmdParms[3].Value = model.FILE_NAME;
cmdParms[4].Value = model.FILE_SYSNAME;
cmdParms[5].Value = model.COMPANY_CODE;
cmdParms[6].Value = model.FILE_TYPE;
DbHelperOra.ExecuteSql(builder.ToString(), cmdParms);
}
public bool Add(SMZJ.Model.TB_QUOTA_DETAIL model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into TB_QUOTA_DETAIL(");
builder.Append("AUTO_NO,PD_QUOTA_CODE,COMPANY_NAME,FILE_NAME,FILE_SYSNAME,COMPANY_CODE,FILE_TYPE,ISRECEIVE,PD_UP_MONEY,PD_QUOTA_SERVERPK,IF_SHOW,ISHUIZHI,RECEIVE_MAN,HUIZHI_MAN)");
builder.Append(" values (");
builder.Append(":AUTO_NO,:PD_QUOTA_CODE,:COMPANY_NAME,:FILE_NAME,:FILE_SYSNAME,:COMPANY_CODE,:FILE_TYPE,:ISRECEIVE,:PD_UP_MONEY,:PD_QUOTA_SERVERPK,:IF_SHOW,:ISHUIZHI,:RECEIVE_MAN,:HUIZHI_MAN)");
OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":AUTO_NO", OracleType.Number, 8), new OracleParameter(":PD_QUOTA_CODE", OracleType.VarChar, 200), new OracleParameter(":COMPANY_NAME", OracleType.VarChar, 200), new OracleParameter(":FILE_NAME", OracleType.VarChar, 200), new OracleParameter(":FILE_SYSNAME", OracleType.VarChar, 200), new OracleParameter(":COMPANY_CODE", OracleType.VarChar, 200), new OracleParameter(":FILE_TYPE", OracleType.VarChar, 200), new OracleParameter(":ISRECEIVE", OracleType.Char, 1), new OracleParameter(":PD_UP_MONEY", OracleType.Number, 0x12), new OracleParameter(":PD_QUOTA_SERVERPK", OracleType.NVarChar), new OracleParameter(":IF_SHOW", OracleType.Char, 1), new OracleParameter(":ISHUIZHI", OracleType.Char, 1), new OracleParameter(":RECEIVE_MAN", OracleType.VarChar, 200), new OracleParameter(":HUIZHI_MAN", OracleType.VarChar, 200) };
cmdParms[0].Value = model.AUTO_NO;
cmdParms[1].Value = model.PD_QUOTA_CODE;
cmdParms[2].Value = model.COMPANY_NAME;
cmdParms[3].Value = model.FILE_NAME;
cmdParms[4].Value = model.FILE_SYSNAME;
cmdParms[5].Value = model.COMPANY_CODE;
cmdParms[6].Value = model.FILE_TYPE;
cmdParms[7].Value = model.ISRECEIVE;
cmdParms[8].Value = model.PD_UP_MONEY;
cmdParms[9].Value = model.PD_QUOTA_SERVERPK;
cmdParms[10].Value = model.IF_SHOW;
cmdParms[11].Value = model.ISHUIZHI;
cmdParms[12].Value = model.RECEIVE_MAN;
cmdParms[13].Value = model.HUIZHI_MAN;
return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public bool Update(SMZJ.Model.MYFILETEST model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update MYFILETEST set ");
builder.Append("商品编号=:商品编号,");
builder.Append("商品名称=:商品名称,");
builder.Append("商品小图地址=:商品小图地址");
builder.Append(" where 商品编号=:商品编号 ");
OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":商品编号", OracleType.Number, 4), new OracleParameter(":商品名称", OracleType.VarChar, 0xff), new OracleParameter(":商品小图地址", OracleType.VarChar, 0xff) };
cmdParms[0].Value = model.商品编号;
cmdParms[1].Value = model.商品名称;
cmdParms[2].Value = model.商品小图地址;
return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public bool Update(SMZJ.Model.TB_QUOTA_DETAIL_TMP model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update TB_QUOTA_DETAIL_TMP set ");
builder.Append("PD_QUOTA_CODE=:PD_QUOTA_CODE,");
builder.Append("COMPANY_NAME=:COMPANY_NAME,");
builder.Append("FILE_NAME=:FILE_NAME,");
builder.Append("FILE_SYSNAME=:FILE_SYSNAME,");
builder.Append("COMPANY_CODE=:COMPANY_CODE,");
builder.Append("FILE_TYPE=:FILE_TYPE");
builder.Append(" where AUTO_NO=:AUTO_NO ");
OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":PD_QUOTA_CODE", OracleType.VarChar, 30), new OracleParameter(":COMPANY_NAME", OracleType.VarChar, 50), new OracleParameter(":FILE_NAME", OracleType.VarChar, 30), new OracleParameter(":FILE_SYSNAME", OracleType.VarChar, 50), new OracleParameter(":COMPANY_CODE", OracleType.VarChar, 20), new OracleParameter(":FILE_TYPE", OracleType.VarChar, 20), new OracleParameter(":AUTO_NO", OracleType.Number, 4) };
cmdParms[0].Value = model.PD_QUOTA_CODE;
cmdParms[1].Value = model.COMPANY_NAME;
cmdParms[2].Value = model.FILE_NAME;
cmdParms[3].Value = model.FILE_SYSNAME;
cmdParms[4].Value = model.COMPANY_CODE;
cmdParms[5].Value = model.FILE_TYPE;
cmdParms[6].Value = model.AUTO_NO;
return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public bool Update(SMZJ.Model.MYFILETEST model)
{
return this.dal.Update(model);
}
public void Add(SMZJ.Model.MYFILETEST model)
{
this.dal.Add(model);
}
public void Add(SMZJ.Model.TB_QUOTA_DETAIL model)
{
this.dal.Add(model);
}
public bool Update(SMZJ.Model.TB_QUOTA_DETAIL model)
{
return this.dal.Update(model);
}
public bool UpdateIsReceive(SMZJ.Model.TB_QUOTA_DETAIL model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update TB_QUOTA_DETAIL set ");
builder.Append("ISRECEIVE=:ISRECEIVE");
builder.Append(" where AUTO_NO=:AUTO_NO ");
OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":ISRECEIVE", OracleType.VarChar, 20), new OracleParameter(":AUTO_NO", OracleType.Number, 4) };
cmdParms[0].Value = model.ISRECEIVE;
cmdParms[1].Value = model.AUTO_NO;
return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0);
}