/// <summary>
/// Read record in table.
/// </summary>
/// <param name="id">Id of the object to be read.</param>
/// <returns>Table entry.</returns>
public T Read(int id)
{
using (MySqlDataContext dataContext = new MySqlDataContext(sqlConn))
{
return(dataContext.GetTable <T>().FirstOrDefault(x => x.Id == id));
}
}
public static bool AddNewKey(string strKeyName, List<string> _strValues, string strCreatUID)
{
bool bRs = false;
//insert INTO idx_key VALUES(0,0,'212121',1,now());select @@IDENTITY;
//BLL.SysMag.Login.StrLoginUserID
string strKeyID = DBA.MySqlDbAccess.ExecuteScalar(System.Data.CommandType.Text,
string.Format("insert INTO idx_key VALUES(0,0,'{0}',{1},now());select @@IDENTITY;", strKeyName, strCreatUID)).ToString();
if (!string.IsNullOrEmpty(strKeyID))
{
List<IDXVAL> idxKeyVal = new List<IDXVAL>();
foreach (string strItem in _strValues)
{
idxKeyVal.Add(new IDXVAL()
{
CreateUser = int.Parse(strCreatUID),
KeyID = int.Parse(strKeyID),
VAL = strItem,
Pid = 0,
AutoIDXContent = "",
CreateTime = DateTime.Now
});
}
using (MySqlDataContext db = new MySqlDataContext())
{
db.IDXVAL.BulkInsertPageSize = 100;
db.IDXVAL.BulkInsert(idxKeyVal);
db.SubmitChanges();
}
bRs = true;
}
return bRs;
}
private bool BulkInsert(List <ShowBase> sbs, List <STPa> pa, List <STIV> iv, List <STIpc> ic, List <STPR> pr, List <STDT> dt, List <STPNS> pn, List <STAnS> an, List <STDMc> dc)
{
using (MySqlDataContext db = new MySqlDataContext())
{
db.ShowBase.BulkInsertPageSize = 100;
db.STDT.BulkInsertPageSize = 100;
db.STPa.BulkInsertPageSize = 100;
db.STIV.BulkInsertPageSize = 100;
db.STPR.BulkInsertPageSize = 100;
db.STIpc.BulkInsertPageSize = 100;
db.STPNS.BulkInsertPageSize = 100;
db.STAnS.BulkInsertPageSize = 100;
db.STDMc.BulkInsertPageSize = 100;
db.ShowBase.BulkInsert(sbs);
db.STDT.BulkInsert(dt);
db.STPa.BulkInsert(pa);
db.STIV.BulkInsert(iv);
db.STPR.BulkInsert(pr);
db.STIpc.BulkInsert(ic);
db.STPNS.BulkInsert(pn);
db.STAnS.BulkInsert(an);
db.STDMc.BulkInsert(dc);
db.SubmitChanges();
}
return(true);
}
static CPRSIndex()
{
if (zhouguo.Count == 0)
{
MySqlDataContext db = new MySqlDataContext();
foreach (var x in db.CfGCountry)
{
if (zhouguo.ContainsKey(x.DAimA))
{
continue;
}
zhouguo.Add(x.DAimA, x);
}
}
if (quyu.Count == 0)
{
MySqlDataContext db = new MySqlDataContext();
foreach (var x in db.CfGQUYU)
{
if (quyu.ContainsKey(x.DiZHi))
{
continue;
}
quyu.Add(x.DiZHi, x.QUYU);
}
}
}
private bool EPODOCBulkInsert(List <ShowBase> sbs, List <STPa> pa, List <STIV> iv, List <STIpc> ic, List <STPR> pr, List <STFML> fml, List <STDT> dt, List <STCPc> cpc)
{
using (MySqlDataContext db = new MySqlDataContext())
{
db.ShowBase.BulkInsertPageSize = 100;
db.STDT.BulkInsertPageSize = 100;
db.STPa.BulkInsertPageSize = 100;
db.STIV.BulkInsertPageSize = 100;
db.STPR.BulkInsertPageSize = 100;
db.STIpc.BulkInsertPageSize = 100;
db.STFML.BulkInsertPageSize = 100;
db.STCPc.BulkInsertPageSize = 100;
db.ShowBase.BulkInsert(sbs);
db.STDT.BulkInsert(dt);
db.STPa.BulkInsert(pa);
db.STIV.BulkInsert(iv);
db.STPR.BulkInsert(pr);
db.STIpc.BulkInsert(ic);
db.STFML.BulkInsert(fml);
db.STCPc.BulkInsert(cpc);
db.SubmitChanges();
}
return(true);
}
public static void IniDropDownList(DataGridView dgw, string dbtype, string filetype)
{
dgw.AutoGenerateColumns = false;
dgw.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dgw.Columns[dgw.ColumnCount - 1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
MySqlDataContext db = MySqlHelper.DataContext;
var res = from tmp in db.CfGTemplate
select tmp;
if (dbtype != "")
{
res = res.Where(x => x.DbType == dbtype);
}
if (filetype != "")
{
res = res.Where(x => x.FileType.Contains(filetype));
}
List <tmpinfo> ztlist = (from tmp in res
select new tmpinfo()
{
Id = tmp.ID, Name = tmp.Name, Dbtype = tmp.DbType, Filetype = tmp.FileType, Path = tmp.Path
}).ToList <tmpinfo>();
if (filetype.IndexOf("xls") >= 0)
{
ztlist.Insert(0, new tmpinfo()
{
Id = 0, Name = "新建模板", Dbtype = dbtype, Filetype = "xls|xlsx", Path = ""
});
}
dgw.DataSource = ztlist;
dgw.Parent.Height = dgw.Rows.Count * dgw.RowTemplate.Height + dgw.ColumnHeadersHeight + 8;
dgw.ClearSelection();
}
/// <summary>
/// Creates record in table.
/// </summary>
/// <param name="obj">Object for recording.</param>
/// <returns>true if the operation was successful; otherwise, false.</returns>
public void Create(T obj)
{
using (MySqlDataContext dataContext = new MySqlDataContext(sqlConn))
{
dataContext.GetTable <T>().InsertOnSubmit(obj);
dataContext.SubmitChanges();
}
}
/// <summary>
/// Delete record in table.
/// </summary>
/// <param name="id">Id of the object to be deleted.</param>
/// <returns>true if the operation was successful; otherwise, false.</returns>
public void DeleteById(int id)
{
using (MySqlDataContext dataContext = new MySqlDataContext(sqlConn))
{
T obj = dataContext.GetTable <T>().FirstOrDefault(x => x.Id == id);
dataContext.GetTable <T>().DeleteOnSubmit(obj);
dataContext.SubmitChanges();
}
}
private bool BulkInsert(List<ShowBase> sbs)
{
MySqlDataContext db = new MySqlDataContext();
db.ShowBase.BulkInsertPageSize = 100;
db.ShowBase.BulkInsert(sbs);
db.SubmitChanges();
sbs.Clear();
return true;
}
public InitializeIdentity(ElaAuthContext ctx,
UserManager <AppUser> userManager,
RoleManager <IdentityRole> roleManager,
MySqlDataContext mySqlDataContext)
{
_context = ctx;
_userManager = userManager;
_roleManager = roleManager;
_mySqlDataContext = mySqlDataContext;
}
public MySqlDataGridForm()
{
InitializeComponent();
habraLabel.Text = Label;
habraLabel.LinkClicked += HabraLabel_LinkClicked;
using (var ctx = new MySqlDataContext())
{
dataGridView1.DataSource = ctx.Items.ToList();
}
}
private void ExcelTemplate_Load(object sender, EventArgs e)
{
//if (tmp.ColumnMapping.Count == 0)
//{
foreach (var s in colName)
{
if (tmp.ColumnMapping.ContainsKey(s))
{
continue;
}
tmp.ColumnMapping.Add(s, new ColumnMapping()
{
ExcelColumnName = s, SystemColumnShowName = s
});
}
//}
using (MySqlDataContext con = new MySqlDataContext())
{
switch (tmp.Type.ToUpper())
{
case "CPRS":
ddl = (from x in con.CfGSTColumn
where x.IsCN == 1 && x.IsiDX == 1
orderby x.ShownAme
select x).ToList <CfGSTColumn>();
break;
case "WPI":
ddl = (from x in con.CfGSTColumn
where x.IsWpi == 1 && x.IsiDX == 1
orderby x.ShownAme
select x).ToList <CfGSTColumn>();
break;
case "EPODOC":
ddl = (from x in con.CfGSTColumn
where x.IsEPodOC == 1 && x.IsiDX == 1
orderby x.ShownAme
select x).ToList <CfGSTColumn>();
break;
}
}
ddl.Insert(0, new CfGSTColumn()
{
ShownAme = "忽略"
});
this.ExcelCol.DataSource = ddl;
this.ExcelCol.DisplayMember = "ShownAme";
dataGridView1.AutoGenerateColumns = false;
this.dataGridView1.DataSource = tmp.ColumnMapping.Values.ToList <ColumnMapping>();
}
static XLSWPIIndex()
{
if (zhouguo.Count == 0)
{
MySqlDataContext db = new MySqlDataContext();
foreach (var x in db.CfGCountry)
{
if (zhouguo.ContainsKey(x.DAimA)) continue;
zhouguo.Add(x.DAimA, x);
}
}
}
public static List <IDXVAL> getVal(int _nKeyId)
{
List <IDXVAL> idxKeyVal = null;
MySqlDataContext db = MySqlHelper.DataContext;
var rs = from tmp in db.IDXVAL
where tmp.KeyID == _nKeyId
select tmp;
idxKeyVal = rs.ToList <IDXVAL>();
return(idxKeyVal);
}
public static bool SaveKeyVal(List <IDXKeyVAL> _idxKeyVal)
{
bool bRs = false;
using (MySqlDataContext db = new MySqlDataContext())
{
db.IDXKeyVAL.BulkInsertPageSize = 100;
db.IDXKeyVAL.BulkInsert(_idxKeyVal);
db.SubmitChanges();
}
bRs = true;
return(bRs);
}
static XLSWPIIndex()
{
if (zhouguo.Count == 0)
{
MySqlDataContext db = new MySqlDataContext();
foreach (var x in db.CfGCountry)
{
if (zhouguo.ContainsKey(x.DAimA))
{
continue;
}
zhouguo.Add(x.DAimA, x);
}
}
}
public static List <IDXKeyVAL> getListKeyVal(string _strSid, int _nZid)
{
List <IDXKeyVAL> idxKeyVal = new List <IDXKeyVAL>();
try
{
MySqlDataContext db = MySqlHelper.DataContext;
var rs = from tmp in db.IDXKeyVAL
where tmp.SiD == _strSid && tmp.ZID.Value == _nZid
select tmp;
idxKeyVal = rs.ToList <IDXKeyVAL>();
}
catch (Exception ex)
{
}
return(idxKeyVal);
}
/// <summary>
/// Update record in table.
/// </summary>
/// <param name="obj">Object for updating.</param>
/// <param name="id">Id of the object to be updated.</param>
/// <returns>true if the operation was successful; otherwise, false.</returns>
public void Update(T obj, int id)
{
using (MySqlDataContext dataContext = new MySqlDataContext(sqlConn))
{
T oldObj = dataContext.GetTable <T>().FirstOrDefault(x => x.Id == id);
Type type = typeof(T);
PropertyInfo[] fields = type.GetProperties();
foreach (PropertyInfo field in fields)
{
if (!field.CanWrite || field.Name == "Id")
{
continue;
}
type.GetProperty(field.Name).SetValue(oldObj, type.GetProperty(field.Name).GetValue(obj));
}
dataContext.SubmitChanges();
}
}
public static Dictionary <int, List <int> > getKeyVal(string _strSid, int _nZid)
{
Dictionary <int, List <int> > idxKeyVal = new Dictionary <int, List <int> >();
MySqlDataContext db = MySqlHelper.DataContext;
var rs = getListKeyVal(_strSid, _nZid);
foreach (var item in rs)
{
if (!idxKeyVal.Keys.Contains(item.KeyID.Value))
{
idxKeyVal.Add(item.KeyID.Value, new List <int>());
}
idxKeyVal[item.KeyID.Value].Add(item.Valid.Value);
}
return(idxKeyVal);
}
public static void iniFilterColumn(ComboBox cmb, string dbtype)
{
using (MySqlDataContext db = new MySqlDataContext())
{
cmb.DropDownStyle = ComboBoxStyle.DropDownList;
cmb.Items.Clear();
List <CfGSTColumn> res = null;
switch (dbtype.ToUpper())
{
case "CPRS":
res = (from tmp in db.CfGSTColumn
where tmp.IsCN == 1 && tmp.IsDel == 0
orderby tmp.ShownAme
select tmp).ToList <CfGSTColumn>();
break;
case "WPI":
res = (from tmp in db.CfGSTColumn
where tmp.IsWpi == 1 && tmp.IsDel == 0
orderby tmp.ShownAme
select tmp).ToList <CfGSTColumn>();
break;
case "EPODOC":
res = (from tmp in db.CfGSTColumn
where tmp.IsEPodOC == 1 && tmp.IsDel == 0
orderby tmp.ShownAme
select tmp).ToList <CfGSTColumn>();
break;
}
foreach (var tmp in res)
{
cmb.Items.Add(tmp);
}
cmb.DisplayMember = "showname";
if (cmb.Items.Count > 0)
{
cmb.SelectedIndex = 0;
}
}
}
public AuthenticationService(
ISecurityService securityService,
IEmailService emailService,
IConfiguration configuration,
UserManager <AppUser> userManager,
JwtSettings jwtSettings,
TokenValidationParameters tokenValidationParameters,
ElaAuthContext context,
RoleManager <IdentityRole> roleManager,
MySqlDataContext mySqlDataContext,
ILogger <AuthenticationService> logger)
{
_securityService = securityService;
_userManager = userManager;
_jwtSettings = jwtSettings;
_tokenValidationParameters = tokenValidationParameters;
_context = context;
_roleManager = roleManager;
_mySqlDataContext = mySqlDataContext;
_logger = logger;
}
public static void IniZTDropDownList(ComboBox cb)
{
cb.Items.Clear();
MySqlDataContext db = MySqlHelper.DataContext;
List <ztinfo> ztlist = (from tmp in db.STZTList
where tmp.IsDel.Value == 0
select new ztinfo()
{
ID = tmp.ID, Name = tmp.Name, DbType = tmp.DbType
}).ToList <ztinfo>();
//select new { Name = tmp.Name ,type= tmp.DbType , Id = tmp.ID };
foreach (var zt in ztlist)
{
zt.DisplayName = string.Format("{0}{1}", getcharlen(zt.Name), zt.DbType);
}
cb.DataSource = ztlist;
cb.SelectedIndex = 0;
}
static CPRSIndex()
{
if (zhouguo.Count == 0)
{
MySqlDataContext db = new MySqlDataContext();
foreach (var x in db.CfGCountry)
{
if (zhouguo.ContainsKey(x.DAimA)) continue;
zhouguo.Add(x.DAimA, x);
}
}
if (quyu.Count == 0)
{
MySqlDataContext db = new MySqlDataContext();
foreach (var x in db.CfGQUYU)
{
if (quyu.ContainsKey(x.DiZHi)) continue;
quyu.Add(x.DiZHi, x.QUYU);
}
}
}
/// <summary>
/// 初始化统计字段类型
/// </summary>
/// <param name="cmb"></param>
/// <param name="dbtyp"></param>
/// <param name="itemname"></param>
public static void initChartType(ComboBox cmb, string itemname)
{
using (MySqlDataContext db = new MySqlDataContext())
{
cmb.DropDownStyle = ComboBoxStyle.DropDownList;
cmb.Items.Clear();
var res = from tmp in db.ChartType
where tmp.ItemName == itemname
select tmp;
foreach (var tmp in res)
{
cmb.Items.Add(tmp);
}
cmb.DisplayMember = "ShowName";
cmb.ValueMember = "ItemName";
if (cmb.Items.Count > 0)
{
cmb.SelectedIndex = 0;
}
}
}
/// <summary>
/// 根据统计分析类型 确定 图标的类型
/// </summary>
/// <param name="cmb"></param>
/// <param name="dbtype"></param>
/// <param name="itemname">
/// 年代
/// 区域
/// 申请人
/// 发明人
/// 技术分类
/// 专利类型
/// </param>
public static void initCharColumn(ComboBox cmb, string dbtype, string itemname)
{
using (MySqlDataContext db = new MySqlDataContext())
{
cmb.DropDownStyle = ComboBoxStyle.DropDownList;
cmb.Items.Clear();
List <ChartColumn> res = null;
switch (dbtype.ToUpper())
{
case "CPRS":
res = (from tmp in db.ChartColumn
where tmp.CN == 1 && tmp.ItemName == itemname
select tmp).ToList <ChartColumn>();
break;
case "WPI":
res = (from tmp in db.ChartColumn
where tmp.Wpi == 1 && tmp.ItemName == itemname
select tmp).ToList <ChartColumn>();
break;
case "EPODOC":
res = (from tmp in db.ChartColumn
where tmp.EPodOC == 1 && tmp.ItemName == itemname
select tmp).ToList <ChartColumn>();
break;
}
foreach (var tmp in res)
{
cmb.Items.Add(tmp);
}
cmb.DisplayMember = "ShowName";
if (cmb.Items.Count > 0)
{
cmb.SelectedIndex = 0;
}
}
}
public static void initChartZhiBiao(CheckedListBox cklst, string dbtype, string itemname)
{
using (MySqlDataContext db = new MySqlDataContext())
{
cklst.Items.Clear();
List <ChartZHIbiAO> res = null;
switch (dbtype.ToUpper())
{
case "CPRS":
res = (from tmp in db.ChartZHIbiAO
where tmp.CN == 1 && tmp.ItemName == itemname
select tmp).ToList <ChartZHIbiAO>();
break;
case "WPI":
res = (from tmp in db.ChartZHIbiAO
where tmp.Wpi == 1 && tmp.ItemName == itemname
select tmp).ToList <ChartZHIbiAO>();
break;
case "EPODOC":
res = (from tmp in db.ChartZHIbiAO
where tmp.EPodOC == 1 && tmp.ItemName == itemname
select tmp).ToList <ChartZHIbiAO>();
break;
}
foreach (var tmp in res)
{
cklst.Items.Add(tmp);
}
cklst.DisplayMember = "ShowName";
if (cklst.Items.Count > 0)
{
cklst.SetItemChecked(0, true);
cklst.SelectedIndex = 0;
}
}
}
private bool CNBulkInsert(List <ShowBase> sbs, List <STPa> pa, List <STIV> iv, List <STIpc> ic, List <STPR> pr, List <STDT> dt, List <STQY> qy)
{
using (MySqlDataContext db = new MySqlDataContext())
{
db.ShowBase.BulkInsertPageSize = 100;
db.STDT.BulkInsertPageSize = 100;
db.STPa.BulkInsertPageSize = 100;
db.STIV.BulkInsertPageSize = 100;
db.STPR.BulkInsertPageSize = 100;
db.STIpc.BulkInsertPageSize = 100;
db.STQY.BulkInsertPageSize = 100;
db.ShowBase.BulkInsert(sbs);
db.STDT.BulkInsert(dt);
db.STPa.BulkInsert(pa);
db.STIV.BulkInsert(iv);
db.STPR.BulkInsert(pr);
db.STIpc.BulkInsert(ic);
db.STQY.BulkInsert(qy);
db.SubmitChanges();
}
return(true);
}
/// <summary>
/// 根据统计分析类型 确定 图标的类型
/// </summary>
/// <param name="cmb"></param>
/// <param name="dbtype"></param>
/// <param name="itemname"></param>
public static void initCharYearColumn(ComboBox cmb)
{
using (MySqlDataContext db = new MySqlDataContext())
{
cmb.DropDownStyle = ComboBoxStyle.DropDownList;
cmb.Items.Clear();
List <ChartColumn> res = null;
res = (from tmp in db.ChartColumn
where tmp.ID == 1
select tmp).ToList <ChartColumn>();
foreach (var tmp in res)
{
cmb.Items.Add(tmp);
}
cmb.DisplayMember = "ShowName";
if (cmb.Items.Count > 0)
{
cmb.SelectedIndex = 0;
}
}
}
public static bool UpdateKeyItem(string strKeyName, List <string> _strAddValues, string strCreatUID, string _strKeyID)
{
bool bRs = false;
//insert INTO idx_key VALUES(0,0,'212121',1,now());select @@IDENTITY;
//BLL.SysMag.Login.StrLoginUserID
string strKeyID = _strKeyID;
DBA.MySqlDbAccess.ExecNoQuery(System.Data.CommandType.Text,
string.Format("update idx_key set idx_key='{0}',createuser={1} where id={2} ", strKeyName, strCreatUID, strKeyID));
if (!string.IsNullOrEmpty(strKeyID))
{
List <IDXVAL> idxKeyVal = new List <IDXVAL>();
foreach (string strItem in _strAddValues)
{
idxKeyVal.Add(new IDXVAL()
{
CreateUser = int.Parse(strCreatUID),
KeyID = int.Parse(strKeyID),
VAL = strItem,
Pid = 0,
AutoIDXContent = "",
CreateTime = DateTime.Now
});
}
using (MySqlDataContext db = new MySqlDataContext())
{
db.IDXVAL.BulkInsertPageSize = 100;
db.IDXVAL.BulkInsert(idxKeyVal);
db.SubmitChanges();
}
bRs = true;
}
return(bRs);
}
private bool CNBulkInsert(List<ShowBase> sbs, List<STPa> pa, List<STIV> iv, List<STIpc> ic, List<STPR> pr, List<STDT> dt, List<STQY> qy)
{
using (MySqlDataContext db = new MySqlDataContext())
{
db.ShowBase.BulkInsertPageSize = 100;
db.STDT.BulkInsertPageSize = 100;
db.STPa.BulkInsertPageSize = 100;
db.STIV.BulkInsertPageSize = 100;
db.STPR.BulkInsertPageSize = 100;
db.STIpc.BulkInsertPageSize = 100;
db.STQY.BulkInsertPageSize = 100;
db.ShowBase.BulkInsert(sbs);
db.STDT.BulkInsert(dt);
db.STPa.BulkInsert(pa);
db.STIV.BulkInsert(iv);
db.STPR.BulkInsert(pr);
db.STIpc.BulkInsert(ic);
db.STQY.BulkInsert(qy);
db.SubmitChanges();
}
return true;
}
public static void initLeftTree(TreeView tw, string dbtype)
{
MySqlDataContext db = new MySqlDataContext();
tw.Nodes.Clear();
switch (dbtype.ToUpper())
{
case "CPRS":
var group = from g in db.ChartGroup
where g.CN == 1
select g;
foreach (ChartGroup x in group)
{
var chridren = from y in MySqlHelper.DataContext.ChartItems
where y.ChartGroup == x.ChartGroup1 && y.CN == 1
select y;
TreeNode node = new TreeNode(x.ChartGroup1);
if (chridren.Count() > 0)
{
foreach (var tmp in chridren)
{
TreeNode tmpnode = new TreeNode(tmp.ItemName);
tmpnode.ToolTipText = tmp.ItemDesC;
if (x.ID > 5 || tmp.ItemName.IndexOf("自定义") > 0)
{
tmpnode.ForeColor = Color.Gray;
tmpnode.Text = tmpnode.Text + "(二期)";
}
node.Nodes.Add(tmpnode);
}
}
if (x.ID <= 5)
{
node.Expand();
}
else
{
node.ForeColor = Color.Gray;
node.Text = node.Text + "(二期)";
}
tw.Nodes.Add(node);
}
break;
case "WPI":
var group1 = from g in db.ChartGroup
where g.Wpi == 1
select g;
foreach (ChartGroup x in group1)
{
var chridren = from y in MySqlHelper.DataContext.ChartItems
where y.ChartGroup == x.ChartGroup1 && y.Wpi == 1
select y;
TreeNode node = new TreeNode(x.ChartGroup1);
if (chridren.Count() > 0)
{
foreach (var tmp in chridren)
{
TreeNode tmpnode = new TreeNode(tmp.ItemName);
tmpnode.ToolTipText = tmp.ItemDesC;
if (x.ID > 5 || tmp.ItemName.IndexOf("自定义") > 0)
{
tmpnode.ForeColor = Color.Gray;
tmpnode.Text = tmpnode.Text + "(二期)";
}
node.Nodes.Add(tmpnode);
}
}
if (x.ID <= 5)
{
node.Expand();
}
else
{
node.ForeColor = Color.Gray;
node.Text = node.Text + "(二期)";
}
tw.Nodes.Add(node);
}
break;
case "EPODOC":
var group2 = from g in db.ChartGroup
where g.EPodOC == 1
select g;
foreach (ChartGroup x in group2)
{
var chridren = from y in MySqlHelper.DataContext.ChartItems
where y.ChartGroup == x.ChartGroup1 && y.EPodOC == 1
select y;
TreeNode node = new TreeNode(x.ChartGroup1);
if (chridren.Count() > 0)
{
foreach (var tmp in chridren)
{
TreeNode tmpnode = new TreeNode(tmp.ItemName);
tmpnode.ToolTipText = tmp.ItemDesC;
if (x.ID > 5 || tmp.ItemName.IndexOf("自定义") > 0)
{
tmpnode.ForeColor = Color.Gray;
tmpnode.Text = tmpnode.Text + "(二期)";
}
node.Nodes.Add(tmpnode);
}
}
if (x.ID <= 5)
{
node.Expand();
}
else
{
node.ForeColor = Color.Gray;
node.Text = node.Text + "(二期)";
}
tw.Nodes.Add(node);
}
break;
}
}
public TestMySqlTableService(MySqlDataContext dataContext)
{
_dataContext = dataContext;
}
public MessengerRepository(MySqlDataContext context) : base(context)
{
}
public static void iniFilterColumn(ComboBox cmb, string dbtype)
{
using (MySqlDataContext db = new MySqlDataContext())
{
cmb.DropDownStyle = ComboBoxStyle.DropDownList;
cmb.Items.Clear();
List<CfGSTColumn> res = null;
switch (dbtype.ToUpper())
{
case "CPRS":
res = (from tmp in db.CfGSTColumn
where tmp.IsCN == 1 && tmp.IsDel == 0
orderby tmp.ShownAme
select tmp).ToList<CfGSTColumn>();
break;
case "WPI":
res = (from tmp in db.CfGSTColumn
where tmp.IsWpi == 1 && tmp.IsDel == 0
orderby tmp.ShownAme
select tmp).ToList<CfGSTColumn>();
break;
case "EPODOC":
res = (from tmp in db.CfGSTColumn
where tmp.IsEPodOC == 1 && tmp.IsDel == 0
orderby tmp.ShownAme
select tmp).ToList<CfGSTColumn>();
break;
}
foreach (var tmp in res)
{
cmb.Items.Add(tmp);
}
cmb.DisplayMember = "showname";
if (cmb.Items.Count > 0)
{
cmb.SelectedIndex = 0;
}
}
}
public static void initChartZhiBiao(CheckedListBox cklst, string dbtype, string itemname)
{
using (MySqlDataContext db = new MySqlDataContext())
{
cklst.Items.Clear();
List<ChartZHIbiAO> res = null;
switch (dbtype.ToUpper())
{
case "CPRS":
res = (from tmp in db.ChartZHIbiAO
where tmp.CN == 1 && tmp.ItemName == itemname
select tmp).ToList<ChartZHIbiAO>();
break;
case "WPI":
res = (from tmp in db.ChartZHIbiAO
where tmp.Wpi == 1 && tmp.ItemName == itemname
select tmp).ToList<ChartZHIbiAO>();
break;
case "EPODOC":
res = (from tmp in db.ChartZHIbiAO
where tmp.EPodOC == 1 && tmp.ItemName == itemname
select tmp).ToList<ChartZHIbiAO>();
break;
}
foreach (var tmp in res)
{
cklst.Items.Add(tmp);
}
cklst.DisplayMember = "ShowName";
if (cklst.Items.Count > 0)
{
cklst.SetItemChecked(0, true);
cklst.SelectedIndex = 0;
}
}
}
/// <summary>
/// 初始化统计字段类型
/// </summary>
/// <param name="cmb"></param>
/// <param name="dbtyp"></param>
/// <param name="itemname"></param>
public static void initChartType(ComboBox cmb, string itemname)
{
using (MySqlDataContext db = new MySqlDataContext())
{
cmb.DropDownStyle = ComboBoxStyle.DropDownList;
cmb.Items.Clear();
var res = from tmp in db.ChartType
where tmp.ItemName == itemname
select tmp;
foreach (var tmp in res)
{
cmb.Items.Add(tmp);
}
cmb.DisplayMember = "ShowName";
cmb.ValueMember = "ItemName";
if (cmb.Items.Count > 0)
{
cmb.SelectedIndex = 0;
}
}
}
public static bool SaveKeyVal(List<IDXKeyVAL> _idxKeyVal)
{
bool bRs = false;
using (MySqlDataContext db = new MySqlDataContext())
{
db.IDXKeyVAL.BulkInsertPageSize = 100;
db.IDXKeyVAL.BulkInsert(_idxKeyVal);
db.SubmitChanges();
}
bRs = true;
return bRs;
}
private bool EPODOCBulkInsert(List<ShowBase> sbs, List<STPa> pa, List<STIV> iv, List<STIpc> ic, List<STPR> pr, List<STFML> fml, List<STDT> dt, List<STCPc> cpc)
{
using (MySqlDataContext db = new MySqlDataContext())
{
db.ShowBase.BulkInsertPageSize = 100;
db.STDT.BulkInsertPageSize = 100;
db.STPa.BulkInsertPageSize = 100;
db.STIV.BulkInsertPageSize = 100;
db.STPR.BulkInsertPageSize = 100;
db.STIpc.BulkInsertPageSize = 100;
db.STFML.BulkInsertPageSize = 100;
db.STCPc.BulkInsertPageSize = 100;
db.ShowBase.BulkInsert(sbs);
db.STDT.BulkInsert(dt);
db.STPa.BulkInsert(pa);
db.STIV.BulkInsert(iv);
db.STPR.BulkInsert(pr);
db.STIpc.BulkInsert(ic);
db.STFML.BulkInsert(fml);
db.STCPc.BulkInsert(cpc);
db.SubmitChanges();
}
return true;
}
private bool BulkInsert(List<ShowBase> sbs, List<STPa> pa, List<STIV> iv, List<STIpc> ic, List<STPR> pr, List<STDT> dt, List<STPNS> pn, List<STAnS> an, List<STDc> dc)
{
using (MySqlDataContext db = new MySqlDataContext())
{
db.ShowBase.BulkInsertPageSize = 100;
db.STDT.BulkInsertPageSize = 100;
db.STPa.BulkInsertPageSize = 100;
db.STIV.BulkInsertPageSize = 100;
db.STPR.BulkInsertPageSize = 100;
db.STIpc.BulkInsertPageSize = 100;
db.STPNS.BulkInsertPageSize = 100;
db.STAnS.BulkInsertPageSize = 100;
db.STDc.BulkInsertPageSize = 100;
db.ShowBase.BulkInsert(sbs);
db.STDT.BulkInsert(dt);
db.STPa.BulkInsert(pa);
db.STIV.BulkInsert(iv);
db.STPR.BulkInsert(pr);
db.STIpc.BulkInsert(ic);
db.STPNS.BulkInsert(pn);
db.STAnS.BulkInsert(an);
db.STDc.BulkInsert(dc);
db.SubmitChanges();
}
return true;
}
private bool BulkInsert(List<ShowBase> sbs)
{
MySqlDataContext db = new MySqlDataContext();
db.ShowBase.BulkInsertPageSize = 100;
db.ShowBase.BulkInsert(sbs);
db.SubmitChanges();
sbs.Clear();
return true;
}
/// <summary>
/// 根据统计分析类型 确定 图标的类型
/// </summary>
/// <param name="cmb"></param>
/// <param name="dbtype"></param>
/// <param name="itemname">
/// 年代
/// 区域
/// 申请人
/// 发明人
/// 技术分类
/// 专利类型
/// </param>
public static void initCharColumn(ComboBox cmb, string dbtype, string itemname)
{
using (MySqlDataContext db = new MySqlDataContext())
{
cmb.DropDownStyle = ComboBoxStyle.DropDownList;
cmb.Items.Clear();
List<ChartColumn> res = null;
switch (dbtype.ToUpper())
{
case "CPRS":
res = (from tmp in db.ChartColumn
where tmp.CN == 1 && tmp.ItemName == itemname
select tmp).ToList<ChartColumn>();
break;
case "WPI":
res = (from tmp in db.ChartColumn
where tmp.Wpi == 1 && tmp.ItemName == itemname
select tmp).ToList<ChartColumn>();
break;
case "EPODOC":
res = (from tmp in db.ChartColumn
where tmp.EPodOC == 1 && tmp.ItemName == itemname
select tmp).ToList<ChartColumn>();
break;
}
foreach (var tmp in res)
{
cmb.Items.Add(tmp);
}
cmb.DisplayMember = "ShowName";
if (cmb.Items.Count > 0)
{
cmb.SelectedIndex = 0;
}
}
}
/// <summary>
/// 根据统计分析类型 确定 图标的类型
/// </summary>
/// <param name="cmb"></param>
/// <param name="dbtype"></param>
/// <param name="itemname"></param>
public static void initCharYearColumn(ComboBox cmb)
{
using (MySqlDataContext db = new MySqlDataContext())
{
cmb.DropDownStyle = ComboBoxStyle.DropDownList;
cmb.Items.Clear();
List<ChartColumn> res = null;
res = (from tmp in db.ChartColumn
where tmp.ID == 1
select tmp).ToList<ChartColumn>();
foreach (var tmp in res)
{
cmb.Items.Add(tmp);
}
cmb.DisplayMember = "ShowName";
if (cmb.Items.Count > 0)
{
cmb.SelectedIndex = 0;
}
}
}
public static void initLeftTree(TreeView tw, string dbtype)
{
MySqlDataContext db = new MySqlDataContext();
tw.Nodes.Clear();
switch (dbtype.ToUpper())
{
case "CPRS":
var group = from g in db.ChartGroup
where g.CN == 1
select g;
foreach (ChartGroup x in group)
{
var chridren = from y in MySqlHelper.DataContext.ChartItems
where y.ChartGroup == x.ChartGroup1 && y.CN == 1
select y;
TreeNode node = new TreeNode(x.ChartGroup1);
if (chridren.Count() > 0)
{
foreach (var tmp in chridren)
{
TreeNode tmpnode = new TreeNode(tmp.ItemName);
tmpnode.ToolTipText = tmp.ItemDesC;
if (x.ID > 5 || tmp.ItemName.IndexOf("自定义") > 0)
{
tmpnode.ForeColor = Color.Gray;
tmpnode.Text = tmpnode.Text + "(二期)";
}
node.Nodes.Add(tmpnode);
}
}
if (x.ID <= 5)
{
node.Expand();
}
else
{
node.ForeColor = Color.Gray;
node.Text = node.Text + "(二期)";
}
tw.Nodes.Add(node);
}
break;
case "WPI":
var group1 = from g in db.ChartGroup
where g.Wpi == 1
select g;
foreach (ChartGroup x in group1)
{
var chridren = from y in MySqlHelper.DataContext.ChartItems
where y.ChartGroup == x.ChartGroup1 && y.Wpi == 1
select y;
TreeNode node = new TreeNode(x.ChartGroup1);
if (chridren.Count() > 0)
{
foreach (var tmp in chridren)
{
TreeNode tmpnode = new TreeNode(tmp.ItemName);
tmpnode.ToolTipText = tmp.ItemDesC;
if (x.ID > 5 || tmp.ItemName.IndexOf("自定义") > 0)
{
tmpnode.ForeColor = Color.Gray;
tmpnode.Text = tmpnode.Text + "(二期)";
}
node.Nodes.Add(tmpnode);
}
}
if (x.ID <= 5)
{
node.Expand();
}
else
{
node.ForeColor = Color.Gray;
node.Text = node.Text + "(二期)";
}
tw.Nodes.Add(node);
}
break;
case "EPODOC":
var group2 = from g in db.ChartGroup
where g.EPodOC == 1
select g;
foreach (ChartGroup x in group2)
{
var chridren = from y in MySqlHelper.DataContext.ChartItems
where y.ChartGroup == x.ChartGroup1 && y.EPodOC == 1
select y;
TreeNode node = new TreeNode(x.ChartGroup1);
if (chridren.Count() > 0)
{
foreach (var tmp in chridren)
{
TreeNode tmpnode = new TreeNode(tmp.ItemName);
tmpnode.ToolTipText = tmp.ItemDesC;
if (x.ID > 5 || tmp.ItemName.IndexOf("自定义") > 0)
{
tmpnode.ForeColor = Color.Gray;
tmpnode.Text = tmpnode.Text + "(二期)";
}
node.Nodes.Add(tmpnode);
}
}
if (x.ID <= 5)
{
node.Expand();
}
else
{
node.ForeColor = Color.Gray;
node.Text = node.Text + "(二期)";
}
tw.Nodes.Add(node);
}
break;
}
}
public PlayerRepository(MySqlDataContext context) : base(context)
{
}
