public int CompareTo(object obj)
{
Category1Info b = obj as Category1Info;
if (this.Status < b.Status)
{
return(1);
}
else if (this.Status > b.Status)
{
return(-1);
}
else
{
int result = String.Compare(this.C1ID, b.C1ID);
if (result > 0)
{
return(1);
}
else
{
return(-1);
}
}
}
public void InsertCate1(Category1Info oParam)
{
//foreach( Category1Info item in C1Hash.Values )
//{
// if ( item.C1ID == oParam.C1ID )
// throw new BizException("the same first category ID exists");
//}
//�Զ�����ID��
string _c1ID = "";
int _tmpInt = -1;
string _tmpStr = "";
string sql = "select max(C1ID) from Category1";
_tmpStr = SqlHelper.ExecuteScalar(sql).ToString();
if (_tmpStr.Trim() == "")
_tmpStr = "0";
if (!Util.IsInteger(_tmpStr))
throw new BizException("�Բ��𣬱�����ɴ��������");
_tmpInt = Convert.ToInt32(_tmpStr);
if (_tmpInt >= 99)//����
{
throw new BizException("�Բ��𣬱��Խ�磬���������");
}
_tmpInt++;
if (_tmpInt < 10)
_c1ID = "0" + _tmpInt.ToString();
else
_c1ID = _tmpInt.ToString();
oParam.C1ID = _c1ID;
oParam.SysNo = oParam.SysNo;
//oParam.SysNo = SequenceDac.GetInstance().Create("Category_Sequence");
new CategoryDac().Insert(oParam);
SyncManager.GetInstance().SetDbLastVersion((int)AppEnum.Sync.Category);
C1Hash.Add(oParam.SysNo, oParam);
}
public void ImportCategory()
{
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 category1 ";
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if ( Util.HasMoreRow(ds) )
throw new BizException("the table category 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))
{
try
{
string sql1 = @"select cf.*, cfl.firstcategoryname from ipp2003..category_first cf, ipp2003..category_first_language cfl
where cf.sysno = cfl.firstcategorysysno and languageid = 'cn'";
DataSet ds1 = SqlHelper.ExecuteDataSet(sql1);
foreach(DataRow dr1 in ds1.Tables[0].Rows )
{
Category1Info oC1 = new Category1Info();
oC1.C1ID = Util.TrimNull(dr1["FirstCategoryID"]);
oC1.C1Name = Util.TrimNull(dr1["FirstCategoryName"]);
oC1.Status = Util.TrimIntNull(dr1["Status"]);
this.Insert(oC1);
//insert into convert table
ImportInfo oC1Convert = new ImportInfo();
oC1Convert.OldSysNo = Util.TrimIntNull(dr1["SysNo"]);
oC1Convert.NewSysNo = oC1.SysNo;
new ImportDac().Insert(oC1Convert, "Category1");
string sql2 = @"select a.*, b.secondcategoryname from ipp2003..category_second a, ipp2003..category_second_language b
where a.sysno = b.secondcategorysysno and languageid = 'cn'
and firstcategorysysno = " + Util.TrimIntNull(dr1["SysNo"]);
DataSet ds2 = SqlHelper.ExecuteDataSet(sql2);
foreach( DataRow dr2 in ds2.Tables[0].Rows )
{
Category2Info oC2 = new Category2Info();
oC2.C1SysNo = oC1.SysNo;
oC2.C2ID = Util.TrimNull(dr2["SecondCategoryID"]);
oC2.C2Name = Util.TrimNull(dr2["SecondCategoryName"]);
oC2.Status = Util.TrimIntNull(dr2["Status"]);
this.Insert(oC2);
//insert into convert table
ImportInfo oC2Convert = new ImportInfo();
oC2Convert.OldSysNo = Util.TrimIntNull(dr2["SysNo"]);
oC2Convert.NewSysNo = oC2.SysNo;
new ImportDac().Insert(oC2Convert,"Category2");
string sql3 = @"select a.*, b.thirdcategoryname from ipp2003..category_third a, ipp2003..category_third_language b
where a.sysno = b.thirdcategorysysno and languageid = 'cn'
and secondcategorysysno = "+ Util.TrimIntNull(dr2["SysNo"]);
DataSet ds3 = SqlHelper.ExecuteDataSet(sql3);
foreach( DataRow dr3 in ds3.Tables[0].Rows )
{
Category3Info oC3 = new Category3Info();
oC3.C2SysNo = oC2.SysNo;
oC3.C3ID = Util.TrimNull(dr3["ThirdCategoryID"]);
oC3.C3Name = Util.TrimNull(dr3["ThirdCategoryName"]);
oC3.Status = Util.TrimIntNull(dr3["Status"]);
this.Insert(oC3);
//insert into convert table
ImportInfo oC3Convert = new ImportInfo();
oC3Convert.OldSysNo = Util.TrimIntNull(dr3["SysNo"]);
oC3Convert.NewSysNo = oC3.SysNo;
new ImportDac().Insert(oC3Convert, "Category3");
string sql4 = @"select a.*,b.AttributeName from ipp2003..category_attribute as a, ipp2003..category_attribute_language as b
where
a.ThirdCategorySysNo = b.ThirdCategorySysNo
and a.AttributeID = b.AttributeID
and languageid = 'cn' and AttributeName <>''
and a.thirdcategorysysno = "+ Util.TrimIntNull(dr3["SysNo"]);
DataSet ds4 = SqlHelper.ExecuteDataSet(sql4);
int count = 0;
foreach( DataRow dr4 in ds4.Tables[0].Rows )
{
if ( count == 0)
{
InitAttribute(Util.TrimIntNull(oC3.SysNo));
count ++;
}
CategoryAttributeInfo oCA = new CategoryAttributeInfo();
oCA.C3SysNo = oC3.SysNo;
oCA.AttributeID = Util.TrimNull(dr4["AttributeID"]);
oCA.AttributeName = Util.TrimNull(dr4["AttributeName"]);
oCA.OrderNum = Util.TrimIntNull(dr4["SequenceNo"]);
oCA.Status = Util.TrimIntNull(dr4["Status"]);
new CategoryDac().UpdateAttributeByC3andAID(oCA);
}
}
}
}
}
catch(Exception ex)
{
C1Hash.Clear();
C2Hash.Clear();
C3Hash.Clear();
throw ex;
}
scope.Complete();
}
}
private void Map(Category1Info oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.C1ID = Util.TrimNull(tempdr["C1ID"]);
oParam.C1Name = Util.TrimNull(tempdr["C1Name"]);
oParam.Status = Util.TrimIntNull(tempdr["Status"]);
}
private void InitC1()
{
lock ( categoryLocker )
{
C1Hash.Clear();
string sql = " select * from category1 order by sysno";
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if ( !Util.HasMoreRow(ds))
return;
foreach( DataRow dr in ds.Tables[0].Rows )
{
Category1Info item = new Category1Info();
Map(item, dr);
C1Hash.Add(item.SysNo, item);
}
}
}
public void Update(Category1Info oParam)
{
//foreach(Category1Info item in C1Hash.Values)
//{
// if ( item.SysNo!=oParam.SysNo && item.C1ID == oParam.C1ID)
// throw new BizException("the same third category ID exists");
//}
new CategoryDac().Update(oParam);
SyncManager.GetInstance().SetDbLastVersion( (int)AppEnum.Sync.Category );
if ( C1Hash.ContainsKey(oParam.SysNo))
{
C1Hash.Remove(oParam.SysNo);
C1Hash.Add(oParam.SysNo, oParam);
}
}
public int Update(Category1Info oParam)
{
string sql = @"UPDATE Category1 SET
C1ID=@C1ID,
C1Name=@C1Name, Status=@Status
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int,4);
SqlParameter paramC1ID = new SqlParameter("@C1ID", SqlDbType.NVarChar,20);
SqlParameter paramC1Name = new SqlParameter("@C1Name", SqlDbType.NVarChar,200);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int,4);
paramSysNo.Value = oParam.SysNo;
paramC1ID.Value = oParam.C1ID;
paramC1Name.Value = oParam.C1Name;
paramStatus.Value = oParam.Status;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramC1ID);
cmd.Parameters.Add(paramC1Name);
cmd.Parameters.Add(paramStatus);
return SqlHelper.ExecuteNonQuery(cmd);
}
public int Insert(Category1Info oParam)
{
string sql = @"INSERT INTO Category1
(
SysNo, C1ID, C1Name, Status
)
VALUES (
@SysNo, @C1ID, @C1Name, @Status
)";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int,4);
SqlParameter paramC1ID = new SqlParameter("@C1ID", SqlDbType.NVarChar,20);
SqlParameter paramC1Name = new SqlParameter("@C1Name", SqlDbType.NVarChar,200);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int,4);
paramSysNo.Value = oParam.SysNo;
paramC1ID.Value = oParam.C1ID;
paramC1Name.Value = oParam.C1Name;
paramStatus.Value = oParam.Status;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramC1ID);
cmd.Parameters.Add(paramC1Name);
cmd.Parameters.Add(paramStatus);
return SqlHelper.ExecuteNonQuery(cmd);
}
