public int Update(ManufacturerInfo oParam) { string sql = @"UPDATE Manufacturer SET ManufacturerID=@ManufacturerID, ManufacturerName=@ManufacturerName, BriefName=@BriefName, Note=@Note, Status=@Status WHERE SysNo=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int,4); SqlParameter paramManufacturerID = new SqlParameter("@ManufacturerID", SqlDbType.NVarChar,20); SqlParameter paramManufacturerName = new SqlParameter("@ManufacturerName", SqlDbType.NVarChar,100); SqlParameter paramBriefName = new SqlParameter("@BriefName", SqlDbType.NVarChar,50); SqlParameter paramNote = new SqlParameter("@Note", SqlDbType.NVarChar,2000); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int,4); paramSysNo.Value = oParam.SysNo; paramManufacturerID.Value = oParam.ManufacturerID; paramManufacturerName.Value = oParam.ManufacturerName; paramBriefName.Value = oParam.BriefName; if ( oParam.Note != AppConst.StringNull) paramNote.Value = oParam.Note; else paramNote.Value = System.DBNull.Value; paramStatus.Value = oParam.Status; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramManufacturerID); cmd.Parameters.Add(paramManufacturerName); cmd.Parameters.Add(paramBriefName); cmd.Parameters.Add(paramNote); cmd.Parameters.Add(paramStatus); return SqlHelper.ExecuteNonQuery(cmd); }
public int CompareTo(object obj) { ManufacturerInfo b = obj as ManufacturerInfo; int compare = String.Compare(this.BriefName, b.BriefName); if (compare == 0) { compare = 1; } return(compare); }
/// <summary> /// ���online��CTFilter.ascx /// </summary> /// <param name="c3SysNo"></param> /// <returns></returns> public SortedList GetManuListByC3(int c3SysNo) { string sql = @"select distinct manufacturer.* from manufacturer, product where product.manufacturersysno = manufacturer.sysno and product.status = @show and manufacturer.status = @valid and product.c3sysno = @c3sysno"; sql = sql.Replace("@show", ((int)AppEnum.ProductStatus.Show).ToString()); sql = sql.Replace("@valid", ((int)AppEnum.BiStatus.Valid).ToString()); sql = sql.Replace("@c3sysno", c3SysNo.ToString()); DataSet ds = SqlHelper.ExecuteDataSet(sql); if ( !Util.HasMoreRow(ds)) return null; SortedList sl = new SortedList(10); foreach(DataRow dr in ds.Tables[0].Rows) { ManufacturerInfo item = new ManufacturerInfo(); map(item, dr); sl.Add(item, null); } return sl; }
private void map(ManufacturerInfo oParam, DataRow tempdr) { oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oParam.ManufacturerID = Util.TrimNull(tempdr["ManufacturerID"]); oParam.ManufacturerName = Util.TrimNull(tempdr["ManufacturerName"]); oParam.BriefName = Util.TrimNull(tempdr["BriefName"]); oParam.Note = Util.TrimNull(tempdr["Note"]); oParam.Status = Util.TrimIntNull(tempdr["Status"]); }
private ManufacturerInfo LoadBySql(string sql) { DataSet ds = SqlHelper.ExecuteDataSet(sql); if ( !Util.HasMoreRow(ds)) return null; ManufacturerInfo oManuInfo = new ManufacturerInfo(); map(oManuInfo, ds.Tables[0].Rows[0]); return oManuInfo; }
public int Update(ManufacturerInfo oParam) { string sql = " select top 1 sysno from Manufacturer where ManufacturerID = " + Util.ToSqlString(oParam.ManufacturerID) + " and sysno <> " + oParam.SysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); if ( Util.HasMoreRow(ds) ) throw new BizException("the same Manufacurer ID exists already"); return new ManufacturerDac().Update(oParam); }
public int Insert(ManufacturerInfo oParam) { //string sql = " select top 1 sysno from Manufacturer where ManufacturerID = " + Util.ToSqlString(oParam.ManufacturerID); //DataSet ds = SqlHelper.ExecuteDataSet(sql); //if ( Util.HasMoreRow(ds) ) // throw new BizException("the same Manufacurer ID exists already"); oParam.SysNo = SequenceDac.GetInstance().Create("Manufacturer_Sequence"); oParam.ManufacturerID = oParam.SysNo.ToString(); return new ManufacturerDac().Insert(oParam); }
public void ImportManu() { if ( !AppConfig.IsImportable) throw new BizException("Is Importable is false"); /* do not use the following code after Data Pour in */ string sql = " select top 1 * from Manufacturer "; DataSet ds = SqlHelper.ExecuteDataSet(sql); if ( Util.HasMoreRow(ds) ) throw new BizException("the table Manufacturer is not empty"); TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { string sql1 = "select * from ipp2003..producer"; DataSet ds1 = SqlHelper.ExecuteDataSet(sql1); foreach(DataRow dr1 in ds1.Tables[0].Rows ) { ManufacturerInfo oManu = new ManufacturerInfo(); oManu.ManufacturerID = Util.TrimNull(dr1["ProducerID"]); oManu.ManufacturerName = Util.TrimNull(dr1["ProducerName"]); oManu.BriefName = Util.TrimNull(dr1["ProducerBriefName"]); string orgDesc = ""; if ( Util.TrimNull(dr1["ProducerDescription"])!=AppConst.StringNull) orgDesc += Util.TrimNull(dr1["ProducerDescription"]); string address = ""; if ( Util.TrimNull(dr1["Country"])!=AppConst.StringNull) address += Util.TrimNull(dr1["Country"]); if ( Util.TrimNull(dr1["City"])!=AppConst.StringNull) address += "," + Util.TrimNull(dr1["City"]); if ( Util.TrimNull(dr1["Address"])!=AppConst.StringNull) address += "," + Util.TrimNull(dr1["Address"]); string website = ""; if ( Util.TrimNull(dr1["Web"])!=AppConst.StringNull) website += Util.TrimNull(dr1["Web"]); string note = ""; if ( Util.TrimNull(dr1["Note"])!=AppConst.StringNull) note += Util.TrimNull(dr1["Note"]); if ( orgDesc != "" ) note += "; Desc: " + orgDesc; if ( address != "" ) note +="; Address: " + address; if ( website != "" ) note +="; site: " + website; oManu.Note = note; oManu.Status = Util.TrimIntNull(dr1["Status"]); this.Insert(oManu); //insert into convert table ImportInfo oManuConvert = new ImportInfo(); oManuConvert.OldSysNo = Util.TrimIntNull(dr1["SysNo"]); oManuConvert.NewSysNo = oManu.SysNo; new ImportDac().Insert(oManuConvert, "Manufacturer"); } scope.Complete(); } }