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();
}
}
