static public void CreatDS(out Exception e)
{
try
{
string FileName = "comset.bet";
string filePath = Environment.CurrentDirectory;
if (!System.IO.File.Exists(filePath + @"\" + FileName))
{
intCom = 0;
}
else
{
StreamReader fReader = new StreamReader(filePath + @"\" + FileName);
string strline = "";
if ((strline = fReader.ReadLine()) == null)
{
intCom = 0;
}
else
{
intCom = Int16.Parse(strline.Substring(8, strline.Length - 8));
}
}
CommAccess ca10 = new CommAccess(ConString);
Exception er = null;
LocalDeptName = ca10.GetLocalDept(out LocalDeptName, out er);
if (er != null)
{
e = er;
return;
}
con.ConnectionString = ConString;
dsSys.Tables.Clear();
string sql;
sql = "select * from tbCommCode where vcCommSign='AT' order by vcCommCode";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "AT");
sql = "select * from tbCommCode where vcCommSign='AT' and substring(vcComments,1,1)='Y' order by vcCommCode";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "AT1");
sql = "select * from tbCommCode where vcCommSign='AS'";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "AS");
sql = "select * from tbCommCode where vcCommSign='ERR'";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "ERR");
sql = "select * from tbCommCode where vcCommSign='GT'";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "GoodsGT");
sql = "select * from tbCommCode where vcCommSign='OP'";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "OP");
sql = "select distinct vcAssName,vcSpell from tbAssociator";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "AssSpell");
sql = "select distinct vcGoodsName,vcSpell from tbGoods";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "GoodsSpell");
sql = "select * from tbGoods";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "Goods");
sql = "select vcOperID,vcOperName,vcLimit,vcDeptID,IsDiscount from tbOper";// "select * from tbOper";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "Oper");
sql = "select * from tbCommCode where vcCommSign='LM' ";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "LM");
sql = "select * from tbCommCode where vcCommCode='LM003' and vcCommSign='LM'";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "LM2");
sql = "select * from tbCommCode where vcCommCode<>'LM003' and vcCommSign='LM'";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "LM3");
sql = "select * from tbCommCode where vcCommSign='IG'";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "IG");
//sql="select * from tbCommCode where vcCommSign='FP1'";
sql = "if exists (select * from tbCommCode where vcCommSign=(select 'FP1-'+vcCommCode from tbCommCode where vcCommSign='local')) "
+ " select * from tbCommCode where vcCommSign=(select 'FP1-'+vcCommCode from tbCommCode where vcCommSign='local') else select * from tbCommCode where vcCommSign='FP1'";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "FP1");
//sql="select * from tbCommCode where vcCommSign='FP2'";
sql = "if exists (select * from tbCommCode where vcCommSign=(select 'FP2-'+vcCommCode from tbCommCode where vcCommSign='local')) "
+ " select * from tbCommCode where vcCommSign=(select 'FP2-'+vcCommCode from tbCommCode where vcCommSign='local') else select * from tbCommCode where vcCommSign='FP2'";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "FP2");
//sql="select * from tbCommCode where vcCommSign='FP3'";
sql = "if exists (select * from tbCommCode where vcCommSign=(select 'FP3-'+vcCommCode from tbCommCode where vcCommSign='local')) "
+ " select * from tbCommCode where vcCommSign=(select 'FP3-'+vcCommCode from tbCommCode where vcCommSign='local') else select * from tbCommCode where vcCommSign='FP3'";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "FP3");
//sql="select * from tbCommCode where vcCommSign='FP4'";
sql = "if exists (select * from tbCommCode where vcCommSign=(select 'FP4-'+vcCommCode from tbCommCode where vcCommSign='local')) "
+ " select * from tbCommCode where vcCommSign=(select 'FP4-'+vcCommCode from tbCommCode where vcCommSign='local') else select * from tbCommCode where vcCommSign='FP4'";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "FP4");
//sql="select * from tbCommCode where vcCommSign='FP5'";
sql = "if exists (select * from tbCommCode where vcCommSign=(select 'FP5-'+vcCommCode from tbCommCode where vcCommSign='local')) "
+ " select * from tbCommCode where vcCommSign=(select 'FP5-'+vcCommCode from tbCommCode where vcCommSign='local') else select * from tbCommCode where vcCommSign='FP5'";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "FP5");
sql = "select * from tbCommCode where vcCommSign='FP6'";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "FP6");
sql = "select * from tbCommCode where vcCommSign='GT' order by vcCommCode ";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "GT");
sql = "select * from tbCommCode where vcCommSign='PT'";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "PT");
sql = "select * from tbCommCode where vcCommSign='MD' and vcCommCode<>'CEN00'";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "MD");
sql = "select * from tbCommCode where vcCommSign='BF'";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "BF");
sql = "select * from tbCommCode where vcCommSign='DE'";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "DE");
sql = "select * from tbCommCode where vcCommSign='ES'";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "ES");
sql = "select * from tbCommCode where vcCommSign='OF'";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "OF");
sql = "select * from tbCommCode where vcCommSign='SFlag' and vcCommCode not in('1','2')";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dsSys, "SFlag");
DataTable dtoperfunc = new DataTable();
//sql="select * from tbOperFunc where vcFuncAddress in(select cnvcFuncAddress from tbFunc where cnvcFuncType='CS') order by vcOperID,vcFuncAddress";
sql = "select * from tbOperFunc order by vcOperID,vcFuncAddress";
daptmp = new SqlDataAdapter(sql, con);
daptmp.Fill(dtoperfunc);
ArrayList aloperfunc = new ArrayList();
hsOperFunc = new Hashtable();
foreach (DataRow dr in dtoperfunc.Rows)
{
if (hsOperFunc.ContainsKey(dr["vcOperID"].ToString()))
{
aloperfunc = (ArrayList)hsOperFunc[dr["vcOperID"].ToString()];
CMSMStruct.OperFuncStruct ops = new CMSMData.CMSMStruct.OperFuncStruct();
ops.strOperID = dr["vcOperID"].ToString();
ops.strFuncName = dr["vcFuncName"].ToString();
ops.strFuncAddress = dr["vcFuncAddress"].ToString();
aloperfunc.Add(ops);
}
else
{
aloperfunc = new ArrayList();
CMSMStruct.OperFuncStruct ops = new CMSMData.CMSMStruct.OperFuncStruct();
ops.strOperID = dr["vcOperID"].ToString();
ops.strFuncName = dr["vcFuncName"].ToString();
ops.strFuncAddress = dr["vcFuncAddress"].ToString();
aloperfunc.Add(ops);
hsOperFunc.Add(dr["vcOperID"].ToString(), aloperfunc);
}
}
con.Open();
sql = "select vcCommName from tbCommCode where vcCommSign='SPF' and vcCommCode='Q1'";
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader drr = cmd.ExecuteReader();
drr.Read();
string strQLTime = drr[0].ToString();
drr.Close();
con.Close();
dtQLTime = new DateTime(int.Parse(strQLTime.Substring(0, 4)), int.Parse(strQLTime.Substring(5, 2)), int.Parse(strQLTime.Substring(8, 2)));
CommAccess ca1 = new CommAccess(ConString);
LocalDept = ca1.GetLocalDept(out er);
if (er != null)
{
e = er;
return;
}
CommAccess ca11 = new CommAccess(ConString);
er = null;
CP = ca11.GetCP(out er);
if (er != null)
{
e = er;
return;
}
CommAccess ca2 = new CommAccess(ConString);
er = null;
Card = ca2.GetCard(out er);
if (er != null)
{
e = er;
return;
}
CommAccess ca3 = new CommAccess(ConString);
er = null;
Tel = ca3.GetTel2(out er);
if (er != null)
{
e = er;
return;
}
CommAccess ca4 = new CommAccess(ConString);
er = null;
TP = ca4.GetTP(out er);
if (er != null)
{
e = er;
return;
}
er = null;
MainDept = ca4.GetMainDept(out er);
if (er != null)
{
e = er;
return;
}
e = null;
}
catch (Exception err)
{
e = err;
}
}
