private void btnLoad_Click(object sender, EventArgs e)
{
cardUseType = QC_CardUseType.LoadCardUseType();
this.cmbCardType.Properties.Items.Clear();
foreach (var item in cardUseType)
{
this.cmbCardType.Properties.Items.Add(item);
}
this.cmbCardType.SelectedIndex = 0;
//reposCardUseType.DataSource = cardUseType;
this.repositoryItemGridLookUpEdit1.DataSource = cardUseType;
icInfoDatas.LoadData();
}
public static DbEntityTable <QC_CardUseType> LoadCardUseType()
{
DbEntityTable <QC_CardUseType> result = new DbEntityTable <QC_CardUseType>();
QC_CardUseType cut1 = new QC_CardUseType();
cut1.CUTCode = QC_IC_Info.CardUseType_Veh;
cut1.CUTName = "车取样扣";
result.Add(cut1);
QC_CardUseType cut2 = new QC_CardUseType();
cut2.CUTCode = "CUT002";
cut2.CUTName = "组批样扣";
result.Add(cut2);
DbEntityTable <QC_CheckGroup> groups = new DbEntityTable <QC_CheckGroup>();
groups.LoadData();
foreach (var item in groups)
{
QC_CardUseType cut = new QC_CardUseType();
cut.CUTCode = "CUT_" + item.CheckGroupCode;
cut.CUTName = item.CheckGroupName + "扣";
result.Add(cut);
}
return(result);
}
private void WP_Shcx_Load(object sender, EventArgs e)
{
cg.LoadData();
List <String> cgname = new List <String>();
List <String> wl = new List <String>();
cgname.Add("全部");
wl.Add("全部");
foreach (var item in cg)
{
cgname.Add(item.CheckGroupName);
}
comboBox1.DataSource = cgname;
}
private void UC_Zdpdyj_Load(object sender, EventArgs e)
{
//if (LocalInfo.Current.user.ID == "17116")
//{
// this.保存.Visible = true;
// this.新增.Visible = true;
//}
//else
//{
// this.保存.Visible = false;
// this.新增.Visible = false;
//}
yjs.LoadData();
qCSamplezdpdyjBindingSource.DataSource = yjs;
}
/// <summary>
/// 从视图读取集中计量火车信息，保存到QC_Sample_Veh表中
/// </summary>
public void initdata()
{
trainData = new DbEntityTable <View_train_to_sample>();
trainData.LoadData();
//没有数据时，返回
if (trainData.Count < 1)
{
return;
}
DbEntityTable <QC_Sample_Veh> veh = new DbEntityTable <QC_Sample_Veh>();
foreach (var item in trainData)
{
QC_Sample_Veh sample = new QC_Sample_Veh();
//物流的主键
sample.FetchPlace = item.matchid;
//发站
sample.zpdh = item.FAZHAN;
//物料名称
sample.rwdh = item.WLMC;
sample.VehNo = item.CPH;
sample.CardID = item.HCPH;
sample.begintime = item.GROSSTIME;
sample.SampleState = Xg.Lab.Sample.SampleState.初始状态;
//加入noticebillid
sample.NoticeBillId = System.Guid.NewGuid().ToString();
sample.WLLX = "火运";
veh.Add(sample);
}
veh.Save();
//trans_train_sample = new DbEntityTable<QC_Sample_Veh>();
//foreach (var item in trainData)
//{
// QC_Sample_Veh sample = new QC_Sample_Veh();
// sample.Sample_Veh_ID = item.matchid;
// sample.FAZHAN = item.FAZHAN;
// sample.WLMC = item.WLMC;
// sample.VehNo = item.CPH;
// sample.CardID = item.HCPH;
// sample.begintime = item.GROSSTIME.ToString("yyyy-MM-dd HH:mm:ss");
// sample.SampleState = Xg.Lab.Sample.SampleState.初始状态;
// trans_train_sample.Add(sample);
//}
//trans_train_sample.Save();
}
private void btnImportJudgeRule_Click(object sender, EventArgs e)
{
if (this.openFileDialog1.ShowDialog() == DialogResult.OK)
{
DbEntityTable <QC_QualityRule> rules = new DbEntityTable <QC_QualityRule>();
DataTable dt = Xg.Tools.ExcelHelper.ImportExcelFile(this.openFileDialog1.FileName);
DbEntityTable <QC_Material> mats = new DbEntityTable <QC_Material>();
mats.LoadData();
for (int i = 1; i < dt.Rows.Count; i++)
{
string matCode = dt.Rows[i][0].ToString().Trim();
var mat = from m in mats
where m.MatCode == matCode
select m;
QC_QualityRule rule = new QC_QualityRule();
rule.MatNcId = mat.First <QC_Material>().MatNcId;
rule.LocalQcLevel = dt.Rows[i][2].ToString().Trim();
switch (rule.LocalQcLevel)
{
case "一级":
rule.RuleOrder = 1;
break;
case "二级":
rule.RuleOrder = 2;
break;
case "三级":
rule.RuleOrder = 3;
break;
default:
rule.RuleOrder = 4;
break;
}
string ruleContent = dt.Rows[i][3].ToString().Trim();
rule.RuleStr2Contents(ruleContent);
rule.QualityLevelID = "1001NC100000002GF3MN";
rules.Add(rule);
}
rules.Save();
}
}
private void WP_Zycx_Load(object sender, EventArgs e)
{
this.gridControl1.DataSource = cxs;
cg.LoadData();
List <String> cgname = new List <String>();
cgname.Add("全部");
foreach (var item in cg)
{
cgname.Add(item.CheckGroupName);
}
comboBox1.DataSource = cgname;
List <String> qylx = new List <String>();
qylx.Add("全部");
qylx.Add("快样");
qylx.Add("抽查样");
qylx.Add("普通样");
comboBox2.DataSource = qylx;
}
private void DlgCheckItem_Load(object sender, EventArgs e)
{
// checkGroup.LoadData();
// this.repositoryItemGridLookUpEdit1.DataSource = checkGroup;
// this.repositoryItemGridLookUpEdit1.ValueMember = "CheckGroupCode";
if (string.IsNullOrEmpty(matNcId))
{
data.LoadData();
}
else
{
data.LoadDataByWhere("CheckItemNcId in (select CHECKITEMNCID from QC_MATALLCHECKITEM where MATNCID=@MATNCID)", this.matNcId);
}
if (filterCheckItemIds != null)
{
data.Filter((ck) => !filterCheckItemIds.Contains(ck.CheckItemNcId));
}
this.gridControl1.DataSource = data;
}
private void UC_MatCheckStandard_Load(object sender, EventArgs e)
{
matFlView.LoadDataByWhere("invclasscode like '1%'");
// materials.LoadData();
this.treeList1.DataSource = matFlView;
foreach (TreeListNode item in this.treeList1.Nodes)
{
if (SelectTreeNode(item))
{
break;
}
}
if (LocalInfo.Current.user.ID != "16870")
{
textEdit3.Enabled = false;
}
// this.gridMaterial.DataSource = materialView;
this.gridMaterial.DataSource = materials;
supplierDoc.LoadData();
QC_SupplierDoc allSupplier = new QC_SupplierDoc();
allSupplier.CustName = "所有厂家";
allSupplier.CustShortName = "所有厂家";
supplierDoc.Insert(0, allSupplier);
this.qCSupplierDocBindingSource.DataSource = supplierDoc;
//this.gridCheckItem.DataSource = matCheckItemView;
//this.gridCheckGroup.DataSource = matCheckGroupView;
//this.qCMatQualityLevelViewBindingSource.DataSource = matQualityLevelView;
// this.gridQualityRule.DataSource = matQualityRule;
repositoryItemGridLookUpEdit1.DataSource = matQualityLevelViewBindingSource;
// matQualityRule.ListChanged += matQualityRule_ListChanged;
}
private void WP_Shcx_Load(object sender, EventArgs e)
{
cg.LoadData();
List <String> cgname = new List <String>();
List <String> wl = new List <String>();
cgname.Add("全部");
wl.Add("全部");
foreach (var item in cg)
{
cgname.Add(item.CheckGroupName);
}
comboBox1.DataSource = cgname;
lab.LoadData();
foreach (var item in lab)
{
if (!wl.Contains(item.MatName) && item.MatName != "")
{
wl.Add(item.MatName);
}
}
lab.Clear();
comboBox2.DataSource = wl;
}
private void LoadData()
{
btnSave.Enabled = false;
checkGroup.LoadData();
}
private void QC_Gys_Load(object sender, EventArgs e)
{
gyss.LoadData();
this.qCBDCUBASDOCBindingSource.DataSource = gyss;
}
private void DlgCheckItem_Load(object sender, EventArgs e)
{
data.LoadData();
this.gridControl1.DataSource = data;
}
private void LoadData()
{
checkGroup.LoadData();
data.LoadData();
btnSave.Enabled = false;
}
private void QC_Wuliao_Load(object sender, EventArgs e)
{
wls.LoadData();
this.qCMaterialwlBindingSource.DataSource = wls;
}