/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TMO_SALEORDERITEM GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_BILLID,C_INITIALIZE_ID,C_ORDERNO,C_CONNO,C_INVBASDOCID,C_INVENTORYID,C_UNITID,C_FUNITID,N_NUMBER,D_CONSIGNDATE,D_DELIVERDATE,C_PK_CORP,C_ADVISECALBODYID,C_CURRENCYTYPEID,N_TAXRATE,N_ORIGINALCURPRICE,N_ORIGINALCURTAXPRICE,N_ORIGINALCURTAXMNY,N_ORIGINALCURMNY,C_RECEIPTAREAID,C_RECEIVEADDRESS,C_RECEIPTCORPID,N_ORIGINALCURSUMMNY,C_VFREE1,C_VFREE2,C_VFREE3,C_VDEF1,C_REMARK,N_STATUS,C_INITORDERID from TMO_SALEORDERITEM ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TMO_SALEORDERITEM model = new Mod_TMO_SALEORDERITEM();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TMO_SALEORDERITEM model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TMO_SALEORDERITEM model)
{
return(dal.Add(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TMO_SALEORDERITEM model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TMO_SALEORDERITEM(");
strSql.Append("C_ID,C_BILLID,C_INITIALIZE_ID,C_ORDERNO,C_CONNO,C_INVBASDOCID,C_INVENTORYID,C_UNITID,C_FUNITID,N_NUMBER,D_CONSIGNDATE,D_DELIVERDATE,C_PK_CORP,C_ADVISECALBODYID,C_CURRENCYTYPEID,N_TAXRATE,N_ORIGINALCURPRICE,N_ORIGINALCURTAXPRICE,N_ORIGINALCURTAXMNY,N_ORIGINALCURMNY,C_RECEIPTAREAID,C_RECEIVEADDRESS,C_RECEIPTCORPID,N_ORIGINALCURSUMMNY,C_VFREE1,C_VFREE2,C_VFREE3,C_VDEF1,C_REMARK,N_STATUS,C_INITORDERID)");
strSql.Append(" values (");
strSql.Append(":C_ID,:C_BILLID,:C_INITIALIZE_ID,:C_ORDERNO,:C_CONNO,:C_INVBASDOCID,:C_INVENTORYID,:C_UNITID,:C_FUNITID,:N_NUMBER,:D_CONSIGNDATE,:D_DELIVERDATE,:C_PK_CORP,:C_ADVISECALBODYID,:C_CURRENCYTYPEID,:N_TAXRATE,:N_ORIGINALCURPRICE,:N_ORIGINALCURTAXPRICE,:N_ORIGINALCURTAXMNY,:N_ORIGINALCURMNY,:C_RECEIPTAREAID,:C_RECEIVEADDRESS,:C_RECEIPTCORPID,:N_ORIGINALCURSUMMNY,:C_VFREE1,:C_VFREE2,:C_VFREE3,:C_VDEF1,:C_REMARK,:N_STATUS,:C_INITORDERID)");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_BILLID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_INITIALIZE_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ORDERNO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CONNO", OracleDbType.Varchar2, 100),
new OracleParameter(":C_INVBASDOCID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_INVENTORYID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_UNITID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_FUNITID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_NUMBER", OracleDbType.Decimal, 15),
new OracleParameter(":D_CONSIGNDATE", OracleDbType.Date),
new OracleParameter(":D_DELIVERDATE", OracleDbType.Date),
new OracleParameter(":C_PK_CORP", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ADVISECALBODYID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CURRENCYTYPEID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_TAXRATE", OracleDbType.Decimal, 15),
new OracleParameter(":N_ORIGINALCURPRICE", OracleDbType.Decimal, 15),
new OracleParameter(":N_ORIGINALCURTAXPRICE", OracleDbType.Decimal, 15),
new OracleParameter(":N_ORIGINALCURTAXMNY", OracleDbType.Decimal, 15),
new OracleParameter(":N_ORIGINALCURMNY", OracleDbType.Decimal, 15),
new OracleParameter(":C_RECEIPTAREAID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_RECEIVEADDRESS", OracleDbType.Varchar2, 100),
new OracleParameter(":C_RECEIPTCORPID", OracleDbType.Varchar2, 100),
new OracleParameter(":N_ORIGINALCURSUMMNY", OracleDbType.Decimal, 15),
new OracleParameter(":C_VFREE1", OracleDbType.Varchar2, 100),
new OracleParameter(":C_VFREE2", OracleDbType.Varchar2, 100),
new OracleParameter(":C_VFREE3", OracleDbType.Varchar2, 100),
new OracleParameter(":C_VDEF1", OracleDbType.Varchar2, 100),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 500),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":C_INITORDERID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_ID;
parameters[1].Value = model.C_BILLID;
parameters[2].Value = model.C_INITIALIZE_ID;
parameters[3].Value = model.C_ORDERNO;
parameters[4].Value = model.C_CONNO;
parameters[5].Value = model.C_INVBASDOCID;
parameters[6].Value = model.C_INVENTORYID;
parameters[7].Value = model.C_UNITID;
parameters[8].Value = model.C_FUNITID;
parameters[9].Value = model.N_NUMBER;
parameters[10].Value = model.D_CONSIGNDATE;
parameters[11].Value = model.D_DELIVERDATE;
parameters[12].Value = model.C_PK_CORP;
parameters[13].Value = model.C_ADVISECALBODYID;
parameters[14].Value = model.C_CURRENCYTYPEID;
parameters[15].Value = model.N_TAXRATE;
parameters[16].Value = model.N_ORIGINALCURPRICE;
parameters[17].Value = model.N_ORIGINALCURTAXPRICE;
parameters[18].Value = model.N_ORIGINALCURTAXMNY;
parameters[19].Value = model.N_ORIGINALCURMNY;
parameters[20].Value = model.C_RECEIPTAREAID;
parameters[21].Value = model.C_RECEIVEADDRESS;
parameters[22].Value = model.C_RECEIPTCORPID;
parameters[23].Value = model.N_ORIGINALCURSUMMNY;
parameters[24].Value = model.C_VFREE1;
parameters[25].Value = model.C_VFREE2;
parameters[26].Value = model.C_VFREE3;
parameters[27].Value = model.C_VDEF1;
parameters[28].Value = model.C_REMARK;
parameters[29].Value = model.N_STATUS;
parameters[30].Value = model.C_INITORDERID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TMO_SALEORDERITEM DataRowToModel(DataRow row)
{
Mod_TMO_SALEORDERITEM model = new Mod_TMO_SALEORDERITEM();
if (row != null)
{
if (row["C_ID"] != null)
{
model.C_ID = row["C_ID"].ToString();
}
if (row["C_BILLID"] != null)
{
model.C_BILLID = row["C_BILLID"].ToString();
}
if (row["C_INITIALIZE_ID"] != null)
{
model.C_INITIALIZE_ID = row["C_INITIALIZE_ID"].ToString();
}
if (row["C_ORDERNO"] != null)
{
model.C_ORDERNO = row["C_ORDERNO"].ToString();
}
if (row["C_CONNO"] != null)
{
model.C_CONNO = row["C_CONNO"].ToString();
}
if (row["C_INVBASDOCID"] != null)
{
model.C_INVBASDOCID = row["C_INVBASDOCID"].ToString();
}
if (row["C_INVENTORYID"] != null)
{
model.C_INVENTORYID = row["C_INVENTORYID"].ToString();
}
if (row["C_UNITID"] != null)
{
model.C_UNITID = row["C_UNITID"].ToString();
}
if (row["C_FUNITID"] != null)
{
model.C_FUNITID = row["C_FUNITID"].ToString();
}
if (row["N_NUMBER"] != null && row["N_NUMBER"].ToString() != "")
{
model.N_NUMBER = decimal.Parse(row["N_NUMBER"].ToString());
}
if (row["D_CONSIGNDATE"] != null && row["D_CONSIGNDATE"].ToString() != "")
{
model.D_CONSIGNDATE = DateTime.Parse(row["D_CONSIGNDATE"].ToString());
}
if (row["D_DELIVERDATE"] != null && row["D_DELIVERDATE"].ToString() != "")
{
model.D_DELIVERDATE = DateTime.Parse(row["D_DELIVERDATE"].ToString());
}
if (row["C_PK_CORP"] != null)
{
model.C_PK_CORP = row["C_PK_CORP"].ToString();
}
if (row["C_ADVISECALBODYID"] != null)
{
model.C_ADVISECALBODYID = row["C_ADVISECALBODYID"].ToString();
}
if (row["C_CURRENCYTYPEID"] != null)
{
model.C_CURRENCYTYPEID = row["C_CURRENCYTYPEID"].ToString();
}
if (row["N_TAXRATE"] != null && row["N_TAXRATE"].ToString() != "")
{
model.N_TAXRATE = decimal.Parse(row["N_TAXRATE"].ToString());
}
if (row["N_ORIGINALCURPRICE"] != null && row["N_ORIGINALCURPRICE"].ToString() != "")
{
model.N_ORIGINALCURPRICE = decimal.Parse(row["N_ORIGINALCURPRICE"].ToString());
}
if (row["N_ORIGINALCURTAXPRICE"] != null && row["N_ORIGINALCURTAXPRICE"].ToString() != "")
{
model.N_ORIGINALCURTAXPRICE = decimal.Parse(row["N_ORIGINALCURTAXPRICE"].ToString());
}
if (row["N_ORIGINALCURTAXMNY"] != null && row["N_ORIGINALCURTAXMNY"].ToString() != "")
{
model.N_ORIGINALCURTAXMNY = decimal.Parse(row["N_ORIGINALCURTAXMNY"].ToString());
}
if (row["N_ORIGINALCURMNY"] != null && row["N_ORIGINALCURMNY"].ToString() != "")
{
model.N_ORIGINALCURMNY = decimal.Parse(row["N_ORIGINALCURMNY"].ToString());
}
if (row["C_RECEIPTAREAID"] != null)
{
model.C_RECEIPTAREAID = row["C_RECEIPTAREAID"].ToString();
}
if (row["C_RECEIVEADDRESS"] != null)
{
model.C_RECEIVEADDRESS = row["C_RECEIVEADDRESS"].ToString();
}
if (row["C_RECEIPTCORPID"] != null)
{
model.C_RECEIPTCORPID = row["C_RECEIPTCORPID"].ToString();
}
if (row["N_ORIGINALCURSUMMNY"] != null && row["N_ORIGINALCURSUMMNY"].ToString() != "")
{
model.N_ORIGINALCURSUMMNY = decimal.Parse(row["N_ORIGINALCURSUMMNY"].ToString());
}
if (row["C_VFREE1"] != null)
{
model.C_VFREE1 = row["C_VFREE1"].ToString();
}
if (row["C_VFREE2"] != null)
{
model.C_VFREE2 = row["C_VFREE2"].ToString();
}
if (row["C_VFREE3"] != null)
{
model.C_VFREE3 = row["C_VFREE3"].ToString();
}
if (row["C_VDEF1"] != null)
{
model.C_VDEF1 = row["C_VDEF1"].ToString();
}
if (row["C_REMARK"] != null)
{
model.C_REMARK = row["C_REMARK"].ToString();
}
if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "")
{
model.N_STATUS = decimal.Parse(row["N_STATUS"].ToString());
}
if (row["C_INITORDERID"] != null)
{
model.C_INITORDERID = row["C_INITORDERID"].ToString();
}
}
return(model);
}