public int InsertFreightManArea(FreightManAreaInfo oParam)
{
string sql = @"INSERT INTO FreightMan_Area
(
FreightUserSysNo, AreaSysNo
)
VALUES (
@FreightUserSysNo, @AreaSysNo
);set @SysNo = SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramFreightUserSysNo = new SqlParameter("@FreightUserSysNo", SqlDbType.Int, 4);
SqlParameter paramAreaSysNo = new SqlParameter("@AreaSysNo", SqlDbType.Int, 4);
paramSysNo.Direction = ParameterDirection.Output;
if (oParam.FreightUserSysNo != AppConst.IntNull)
paramFreightUserSysNo.Value = oParam.FreightUserSysNo;
else
paramFreightUserSysNo.Value = System.DBNull.Value;
if (oParam.AreaSysNo != AppConst.IntNull)
paramAreaSysNo.Value = oParam.AreaSysNo;
else
paramAreaSysNo.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramFreightUserSysNo);
cmd.Parameters.Add(paramAreaSysNo);
return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo);
}
public void InsertFreightManArea(string FreightMenList, string AreaSysNoList)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
string[] FreightMen = FreightMenList.Split(',');
string[] AreaSysNo = AreaSysNoList.Split(',');
for (int i = 0; i < FreightMen.Length; i++)
{
for (int j = 0; j < AreaSysNo.Length; j++)
{
string sql = "select * from FreightMan_Area where FreightUserSysNo = " + Int32.Parse(FreightMen[i]) + " and AreaSysNo = " + Int32.Parse(AreaSysNo[j]);
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (!Util.HasMoreRow(ds))
{
FreightManAreaInfo oParam = new FreightManAreaInfo();
oParam.FreightUserSysNo = Int32.Parse(FreightMen[i]);
oParam.AreaSysNo = Int32.Parse(AreaSysNo[j]);
int result = new ASPDac().InsertFreightManArea(oParam);
SyncManager.GetInstance().SetDbLastVersion((int)AppEnum.Sync.ASP);
if (freightManAreaHash == null)
freightManAreaHash = new Hashtable(10);
freightManAreaHash.Add(oParam.SysNo, oParam);
}
}
}
scope.Complete();
}
}
private void Map(FreightManAreaInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.FreightUserSysNo = Util.TrimIntNull(tempdr["FreightUserSysNo"]);
oParam.AreaSysNo = Util.TrimIntNull(tempdr["AreaSysNo"]);
}
public void InitFreightManArea()
{
lock (freightManAreaLock)
{
freightManAreaHash.Clear();
string sql = "select * from FreightMan_Area";
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (!Util.HasMoreRow(ds))
return;
foreach (DataRow dr in ds.Tables[0].Rows)
{
FreightManAreaInfo item = new FreightManAreaInfo();
Map(item, dr);
freightManAreaHash.Add(item.SysNo, item);
}
}
}