private void InsertDetail(int i, DataView dv, string pModule) { HtmlTableRow htr = this.tablea.FindControl(dv.Table.Rows[i]["TYPENAME"].ToString()+pModule.Substring(3)) as HtmlTableRow; if (htr != null) { Detail_RP_BOXMONTHYEARDETAIL detail = new Detail_RP_BOXMONTHYEARDETAIL(); detail.BOXMONTHYEARID = ViewState["Guid"] as string; detail.LINEHAS = pModule; detail.LINENAME = htr.ID.Substring(0, htr.ID.Length - 2) ; detail.ID = Guid.NewGuid().ToString(); string EMTTEU = (htr.FindControl("EmtTEU" + htr.ID) as NumericTextBox).Value; detail.EMTTEU = string.IsNullOrEmpty(EMTTEU) ? 0 : Convert.ToInt32(EMTTEU); string EMT45 = (htr.FindControl("EMT45" + htr.ID) as NumericTextBox).Value; detail.EMT45 = string.IsNullOrEmpty(EMT45) ? 0 : Convert.ToInt32(EMT45); string EMT40 = (htr.FindControl("EMT40" + htr.ID) as NumericTextBox).Value; detail.EMT40 = string.IsNullOrEmpty(EMT40) ? 0 : Convert.ToInt32(EMT40); string EMT20 = (htr.FindControl("EMT20" + htr.ID) as NumericTextBox).Value; detail.EMT20 = string.IsNullOrEmpty(EMT20) ? 0 : Convert.ToInt32(EMT20); string EMTOTHER = (htr.FindControl("EMTOTHER" + htr.ID) as NumericTextBox).Value; detail.EMTOTHER = string.IsNullOrEmpty(EMTOTHER) ? 0 : Convert.ToInt32(EMTOTHER); string HAVENTEU = (htr.FindControl("HAVENTEU" + htr.ID) as NumericTextBox).Value; detail.HAVENTEU = string.IsNullOrEmpty(HAVENTEU) ? 0 : Convert.ToInt32(HAVENTEU); string HAVEN45 = (htr.FindControl("HAVEN45" + htr.ID) as NumericTextBox).Value; detail.HAVEN45 = string.IsNullOrEmpty(HAVEN45) ? 0 : Convert.ToInt32(HAVEN45); string HAVEN40 = (htr.FindControl("HAVEN40" + htr.ID) as NumericTextBox).Value; detail.HAVEN40 = string.IsNullOrEmpty(HAVEN40) ? 0 : Convert.ToInt32(HAVEN40); string HAVEN20 = (htr.FindControl("HAVEN20" + htr.ID) as NumericTextBox).Value; detail.HAVEN20 = string.IsNullOrEmpty(HAVEN20) ? 0 : Convert.ToInt32(HAVEN20); string HAVENOTHER = (htr.FindControl("HAVENOTHER" + htr.ID) as NumericTextBox).Value; detail.HAVENOTHER = string.IsNullOrEmpty(HAVENOTHER) ? 0 : Convert.ToInt32(HAVENOTHER); string TOTALWEIGHT = (htr.FindControl("HavTotle" + htr.ID) as TextBox).Text; detail.TOTALWEIGHT = string.IsNullOrEmpty(TOTALWEIGHT) ? 0 : Convert.ToDecimal(TOTALWEIGHT); string GOODSWEIGHT = (htr.FindControl("HavgoodsWeight" + htr.ID) as TextBox).Text; detail.GOODSWEIGHT = string.IsNullOrEmpty(GOODSWEIGHT) ? 0 : Convert.ToDecimal(GOODSWEIGHT); new Rp_BoxMonthYearDetail().Insert(detail.ID, detail.BOXMONTHYEARID, detail.LINEHAS, detail.LINENAME, detail.EMTTEU, detail.EMT45, detail.EMT40, detail.EMT20, detail.EMTOTHER, detail.HAVENTEU, detail.HAVEN45, detail.HAVEN40, detail.HAVEN20, detail.HAVENOTHER, detail.TOTALWEIGHT, detail.GOODSWEIGHT); } }
/// <summary> /// /// 编写日期:2010-4-21 /// 编写人:GWF /// </summary> /// <param name="ID"></param> public Detail_RP_BOXMONTHYEAR GetDetail(string ID) { Database db = DatabaseFactory.CreateDatabase(CawConnStr); string strSql = (db.DbProviderFactory.ToString() != "System.Data.OracleClient.OracleClientFactory") ? "SELECT A.*, B.DATASTATUS,B.DATASTATUS_NAME FROM RP_BOXMONTHYEAR A,CAW_DATESTATUS B WHERE A.ID=B.KEYGUID and A.ID=@ID " : "SELECT A.*, B.DATASTATUS,B.DATASTATUS_NAME FROM RP_BOXMONTHYEAR A,CAW_DATESTATUS B WHERE A.ID=B.KEYGUID and A.ID=:ID "; DbCommand cmd = db.GetSqlStringCommand(strSql); db.AddInParameter(cmd, "ID", DbType.String, ID); Detail_RP_BOXMONTHYEAR myDetail = new Detail_RP_BOXMONTHYEAR(); using (IDataReader myReader = db.ExecuteReader(cmd)) { if (myReader.Read()) { if (!Convert.IsDBNull(myReader["ID"])) { myDetail.ID = Convert.ToString(myReader["ID"]); } if (!Convert.IsDBNull(myReader["CMPID"])) { myDetail.CMPID = Convert.ToString(myReader["CMPID"]); } if (!Convert.IsDBNull(myReader["CMPNAME"])) { myDetail.CMPNAME = Convert.ToString(myReader["CMPNAME"]); } if (!Convert.IsDBNull(myReader["YEAR"])) { myDetail.YEAR = Convert.ToInt32(myReader["YEAR"]); } if (!Convert.IsDBNull(myReader["MONTH"])) { myDetail.MONTH = Convert.ToInt32(myReader["MONTH"]); } if (!Convert.IsDBNull(myReader["DATETIME"])) { myDetail.DATETIME = Convert.ToDateTime(myReader["DATETIME"]); } if (!Convert.IsDBNull(myReader["ISMONTH"])) { myDetail.ISMONTH = Convert.ToInt32(myReader["ISMONTH"]); } if (!Convert.IsDBNull(myReader["INOUT"])) { myDetail.INOUT = Convert.ToInt32(myReader["INOUT"]); } if (!Convert.IsDBNull(myReader["UPDATETIME"])) { myDetail.UPDATETIME = Convert.ToDateTime(myReader["UPDATETIME"]); } if (!Convert.IsDBNull(myReader["DATASTATUS"])) { myDetail.DATASTATUS = Convert.ToString(myReader["DATASTATUS"]); } if (!Convert.IsDBNull(myReader["DATASTATUS_NAME"])) { myDetail.DATASTATUS_NAME = Convert.ToString(myReader["DATASTATUS_NAME"]); } } } string strdetail = string.Format("select * from RP_BOXMONTHYEARDETAIL where BOXMONTHYEARID='{0}'", ID); DbCommand cmd1 = db.GetSqlStringCommand(strdetail); DataView dv= db.ExecuteDataView(cmd1); IList<Detail_RP_BOXMONTHYEARDETAIL> dlist = new List<Detail_RP_BOXMONTHYEARDETAIL>(); foreach (DataRow dr in dv.Table.Rows) { Detail_RP_BOXMONTHYEARDETAIL p = new Detail_RP_BOXMONTHYEARDETAIL(); p.ID = dr["ID"].ToString(); p.BOXMONTHYEARID = myDetail.ID; p.LINEHAS = dr["LINEHAS"].ToString(); p.LINENAME = dr["LINENAME"].ToString(); p.EMTTEU = Convert.ToInt32(dr["EMTTEU"]); p.EMT45 = Convert.ToInt32(dr["EMT45"]); p.EMT40 = Convert.ToInt32(dr["EMT40"]); p.EMT20 = Convert.ToInt32(dr["EMT20"]); p.EMTOTHER = Convert.ToInt32(dr["EMTOTHER"]); p.HAVENTEU = Convert.ToInt32(dr["HAVENTEU"]); p.HAVEN45 = Convert.ToInt32(dr["HAVEN45"]); p.HAVEN40 = Convert.ToInt32(dr["HAVEN40"]); p.HAVEN20 = Convert.ToInt32(dr["HAVEN20"]); p.HAVENOTHER = Convert.ToInt32(dr["HAVENOTHER"]); p.TOTALWEIGHT = Convert.ToDecimal(dr["TOTALWEIGHT"]); p.GOODSWEIGHT = Convert.ToDecimal(dr["GOODSWEIGHT"]); dlist.Add(p); } myDetail.Detail_RP_BOXMONTHYEARDETAIL = dlist; return myDetail; }
/// <summary> /// /// 编写日期:2010-4-21 /// 编写人:GWF /// </summary> /// <param name="ID"></param> public Detail_RP_BOXMONTHYEARDETAIL GetDetail(string ID) { Database db = DatabaseFactory.CreateDatabase(CawConnStr); string strSql = (db.DbProviderFactory.ToString() != "System.Data.OracleClient.OracleClientFactory") ? "SELECT * FROM RP_BOXMONTHYEARDETAIL WHERE ID=@ID " : "SELECT * FROM RP_BOXMONTHYEARDETAIL WHERE ID=:ID "; DbCommand cmd = db.GetSqlStringCommand(strSql); db.AddInParameter(cmd, "ID", DbType.String, ID); Detail_RP_BOXMONTHYEARDETAIL myDetail = new Detail_RP_BOXMONTHYEARDETAIL(); using (IDataReader myReader = db.ExecuteReader(cmd)) { if (myReader.Read()) { if (!Convert.IsDBNull(myReader["ID"])) { myDetail.ID = Convert.ToString(myReader["ID"]); } if (!Convert.IsDBNull(myReader["BOXMONTHYEARID"])) { myDetail.BOXMONTHYEARID = Convert.ToString(myReader["BOXMONTHYEARID"]); } if (!Convert.IsDBNull(myReader["LINEHAS"])) { myDetail.LINEHAS = Convert.ToString(myReader["LINEHAS"]); } if (!Convert.IsDBNull(myReader["LINENAME"])) { myDetail.LINENAME = Convert.ToString(myReader["LINENAME"]); } if (!Convert.IsDBNull(myReader["EMTTEU"])) { myDetail.EMTTEU = Convert.ToInt32(myReader["EMTTEU"]); } if (!Convert.IsDBNull(myReader["EMT45"])) { myDetail.EMT45 = Convert.ToInt32(myReader["EMT45"]); } if (!Convert.IsDBNull(myReader["EMT40"])) { myDetail.EMT40 = Convert.ToInt32(myReader["EMT40"]); } if (!Convert.IsDBNull(myReader["EMT20"])) { myDetail.EMT20 = Convert.ToInt32(myReader["EMT20"]); } if (!Convert.IsDBNull(myReader["EMTOTHER"])) { myDetail.EMTOTHER = Convert.ToInt32(myReader["EMTOTHER"]); } if (!Convert.IsDBNull(myReader["HAVENTEU"])) { myDetail.HAVENTEU = Convert.ToInt32(myReader["HAVENTEU"]); } if (!Convert.IsDBNull(myReader["HAVEN45"])) { myDetail.HAVEN45 = Convert.ToInt32(myReader["HAVEN45"]); } if (!Convert.IsDBNull(myReader["HAVEN40"])) { myDetail.HAVEN40 = Convert.ToInt32(myReader["HAVEN40"]); } if (!Convert.IsDBNull(myReader["HAVEN20"])) { myDetail.HAVEN20 = Convert.ToInt32(myReader["HAVEN20"]); } if (!Convert.IsDBNull(myReader["HAVENOTHER"])) { myDetail.HAVENOTHER = Convert.ToInt32(myReader["HAVENOTHER"]); } if (!Convert.IsDBNull(myReader["TOTALWEIGHT"])) { myDetail.TOTALWEIGHT = Convert.ToDecimal(myReader["TOTALWEIGHT"]); } if (!Convert.IsDBNull(myReader["GOODSWEIGHT"])) { myDetail.GOODSWEIGHT = Convert.ToDecimal(myReader["GOODSWEIGHT"]); } } } return myDetail; }