/// <summary> /// 加载供应商档案信息 /// </summary> private void LoadInfo(string supperId) { if (!string.IsNullOrEmpty(supperId)) { //1.加载供应商档案主信息 DataTable dt = DBHelper.GetTable("查看一条供应商档案信息", "tb_supplier", "*", " sup_id='" + supperId + "'", "", ""); if (dt != null && dt.Rows.Count > 0) { tb_supplier model = new tb_supplier(); CommonFuncCall.SetModlByDataTable(model, dt); CommonFuncCall.SetShowControlValue(this, model, "View"); DataTable dt_bill = CommonFuncCall.GetDataTable(); if (!string.IsNullOrEmpty(model.sup_type)) { lblsup_type.Text = CommonFuncCall.GetBillNameByBillCode(dt_bill, model.sup_type); } if (!string.IsNullOrEmpty(model.unit_properties)) { lblunit_properties.Text = CommonFuncCall.GetBillNameByBillCode(dt_bill, model.unit_properties); } if (!string.IsNullOrEmpty(model.price_type)) { lblprice_type.Text = CommonFuncCall.GetBillNameByBillCode(dt_bill, model.price_type); } if (!string.IsNullOrEmpty(model.credit_class)) { lblcredit_class.Text = CommonFuncCall.GetBillNameByBillCode(dt_bill, model.credit_class); } if (!string.IsNullOrEmpty(model.county)) { lblsup_address.Text = CommonFuncCall.GetAddress(model.county) + " " + lblsup_address.Text; } else { if (!string.IsNullOrEmpty(model.city)) { lblsup_address.Text = CommonFuncCall.GetAddress(model.city) + " " + lblsup_address.Text; } else { if (!string.IsNullOrEmpty(model.province)) { lblsup_address.Text = CommonFuncCall.GetAddress(model.province) + " " + lblsup_address.Text; } } } } } }
/// <summary> /// 加载供应商档案信息 /// </summary> private void LoadInfo(string workingTimeId) { if (!string.IsNullOrEmpty(workingTimeId)) { //1.加载工时档案主信息 DataTable dt = DBHelper.GetTable("查看一条工时档案信息", "v_workhours_users", "*", " whours_id='" + workingTimeId + "'", "", ""); if (dt != null && dt.Rows.Count > 0) { tb_workhours tb_workhours_Model = new tb_workhours(); CommonFuncCall.SetModlByDataTable(tb_workhours_Model, dt); CommonFuncCall.SetShowControlValue(this, tb_workhours_Model, ""); if (tb_workhours_Model.whours_type == "1") { radIsWorkTime.Checked = true; } else if (tb_workhours_Model.whours_type == "2") { radIsQuota.Checked = true; } lblcreate_by.Text = dt.Rows[0]["create_username"].ToString(); lblupdate_by.Text = dt.Rows[0]["update_username"].ToString(); if (!string.IsNullOrEmpty(lblcreate_time.Text)) { long ticks = (long)Convert.ToInt64(lblcreate_time.Text); lblcreate_time.Text = Common.UtcLongToLocalDateTime(ticks).ToString(); } if (!string.IsNullOrEmpty(lblupdate_time.Text)) { long ticks = (long)Convert.ToInt64(lblupdate_time.Text); lblupdate_time.Text = Common.UtcLongToLocalDateTime(ticks).ToString(); } DataTable dt_bill = CommonFuncCall.GetDataTable(); if (!string.IsNullOrEmpty(tb_workhours_Model.repair_type)) { lblrepair_type.Text = CommonFuncCall.GetBillNameByBillCode(dt_bill, tb_workhours_Model.repair_type); } } } }
/// <summary> /// 设置选择项后状态 /// </summary> //void SetSelectedStatus() //{ // //已选择状态列表 // List<string> listFiles = new List<string>(); // listIDs.Clear(); // listStart.Clear(); // listStop.Clear(); // foreach (DataGridViewRow dgvr in dgvSupplierList.Rows) // { // if (Convert.ToBoolean(dgvr.Cells[colCheck.Name].EditedFormattedValue)) // { // string cont_id = dgvr.Cells[suppID.Name].Value.ToString(); // listIDs.Add(cont_id); // //if (dgvr.Cells[status.Name].Tag == null) // //{ // // continue; // //} // //enumStatus = (DataSources.EnumStatus)Convert.ToInt32(dgvr.Cells[status.Name].Value);//状态 // enumStatus = (DataSources.EnumStatus)Convert.ToInt32(dgvr.Cells[status.Name].Value);//状态 // if (enumStatus == DataSources.EnumStatus.Start) // { // listStart.Add(cont_id); // } // else if (enumStatus == DataSources.EnumStatus.Stop) // { // listStop.Add(cont_id); // } // } // } // #region 设置启用/停用 // if (listStart.Count > 0 && listStop.Count > 0) // { // btnStatus.Enabled = false; // } // else if (listStart.Count == 0 && listStop.Count == 0) // { // btnStatus.Enabled = false; // } // else if (listStart.Count > 0 && listStop.Count == 0) // { // btnStatus.Enabled = true; // btnStatus.Caption = "停用"; // enumStatus = DataSources.EnumStatus.Start; // } // else if (listStart.Count == 0 && listStop.Count > 0) // { // btnStatus.Enabled = true; // btnStatus.Caption = "启用"; // enumStatus = DataSources.EnumStatus.Stop; // } // #endregion //} #endregion #region dgv事件 private void gvSupplierList_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e) { if (e.Value == null || e.Value.ToString() == string.Empty) { return; } string fieldNmae = dgvSupplierList.Columns[e.ColumnIndex].DataPropertyName; if (fieldNmae.Equals("create_time") || fieldNmae.Equals("update_time")) { long ticks = (long)e.Value; e.Value = Common.UtcLongToLocalDateTime(ticks); } if (fieldNmae.Equals("status")) { DataSources.EnumStatus enumDataSources = (DataSources.EnumStatus)Convert.ToInt16(e.Value.ToString()); //e.Value = enumDataSources.ToString(); e.Value = DataSources.GetDescription(enumDataSources, true); } if (fieldNmae.Equals("unit_properties") || fieldNmae.Equals("sup_type") || fieldNmae.Equals("credit_class")) { e.Value = CommonFuncCall.GetBillNameByBillCode(dt_bill, e.Value.ToString()); } }