public void SetUp()
{
_settings = new Tailviewer.Settings.DataSources();
_scheduler = new ManualTaskScheduler();
_dataSources = new DataSources(_scheduler, _settings);
_model = new MergedDataSourceViewModel(_dataSources.AddGroup());
}
public tblmembervisaactiveDlg(DataSources.dsRetirementCenter.tblmembervisaactiveRow row)
{
InitializeComponent();
_row = row;
dedatehala.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _row, "datehala", true));
tbhalarem.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _row, "halarem", true));
}
public JobEditorWFrm(DataSources.dsNU.JobRow row)
{
InitializeComponent();
_row = row;
jobBindingSource.DataSource = _row;
JobNameTextEdit.DataBindings.Add(new Binding("EditValue", _row, "JobName", true));
}
public static bool UpdateBulkRouteEquipment(SqlCommand cmd, DataSources.dsData.EquipmentDataTable BulkTable)
{
bool outPut = false;
try
{
SqlBulkCopy bulkCopy = new SqlBulkCopy(cmd.Connection);
bulkCopy.ColumnMappings.Clear();
bulkCopy.ColumnMappings.Add("EquipmentId", "EquipmentId"); bulkCopy.ColumnMappings.Add("SerialNumber", "SerialNumber");
bulkCopy.ColumnMappings.Add("Material", "Material"); bulkCopy.ColumnMappings.Add("Description", "Description");
bulkCopy.ColumnMappings.Add("FunctionalId", "FunctionalId"); bulkCopy.ColumnMappings.Add("FunctionalLocation", "FunctionalLocation");
bulkCopy.ColumnMappings.Add("ValidFrom", "ValidFrom"); bulkCopy.ColumnMappings.Add("InventoryNo", "InventoryNo");
bulkCopy.ColumnMappings.Add("ConstructYear", "ConstructYear"); bulkCopy.ColumnMappings.Add("BrandId", "BrandId");
bulkCopy.ColumnMappings.Add("userin", "userin"); bulkCopy.ColumnMappings.Add("datein", "datein");
bulkCopy.DestinationTableName = BulkTable.TableName;
bulkCopy.BatchSize = BulkTable.Count;
//deleting data before saving new 1
cmd.CommandText = "delete from Equipment";
cmd.ExecuteNonQuery();
//saving bulk
bulkCopy.WriteToServer(BulkTable);
outPut = true;
}
catch (SqlException ex)
{
Logger.Error("Error while trying to save Equipment Bulk - " + ex.Message, ex);
}
return outPut;
}
public static bool UpdateBulkRouteCustomer(SqlCommand cmd, DataSources.dsData.RouteCustomerDataTable BulkTable)
{
bool outPut = false;
try
{
SqlBulkCopy bulkCopy = new SqlBulkCopy(cmd.Connection);
bulkCopy.ColumnMappings.Clear();
bulkCopy.ColumnMappings.Add("CustomerId", "CustomerId"); bulkCopy.ColumnMappings.Add("RouteNumber", "RouteNumber");
bulkCopy.ColumnMappings.Add("RouteCustomerStateId", "RouteCustomerStateId"); bulkCopy.ColumnMappings.Add("DeliveryDay", "DeliveryDay");
bulkCopy.ColumnMappings.Add("userin", "userin"); bulkCopy.ColumnMappings.Add("datein", "datein");
bulkCopy.DestinationTableName = BulkTable.TableName;
bulkCopy.BatchSize = BulkTable.Count;
//deleting data before saving new 1
cmd.CommandText = "delete from RouteCustomer";
cmd.ExecuteNonQuery();
//saving bulk
bulkCopy.WriteToServer(BulkTable);
outPut = true;
}
catch (SqlException ex)
{
Logger.Error("Error while trying to save RouteCustomer Bulk - " + ex.Message, ex);
}
return outPut;
}
public GovEditorWFrm(DataSources.dsGM.GovRow row)
{
InitializeComponent();
_row = row;
govBindingSource.DataSource = _row;
GovNameTextEdit.DataBindings.Add(new Binding("EditValue", _row, "GovName", true));
}
public RoleEditorWFrm(DataSources.dsGM.RoleRow row)
{
InitializeComponent();
_row = row;
DataBindingSource.DataSource = _row;
RoleNameTextEdit.DataBindings.Add(new Binding("EditValue", _row, "RoleName", true));
}
public TblMemberAmanatWFrm(DataSources.dsRetirementCenter.TblMemberAmanatRow row, bool insert, bool update, bool delete)
{
InitializeComponent();
_row = row;
_Insert = insert;
_Update = update;
_Delete = delete;
}
public static void CreateDefaultEmployee(ref DataSources.dsData.EmployeeRow row)
{
row.EmployeeName = DefaultEmployeeName;
row.EmployeeNameFull = DefaultEmployeeName;
row.JobTitleId = UnknownJobTitleId;
row.datein = DataManager.defaultInstance.GetServerDatetime;
row.userin = UserManager.defaultInstance.UserInfo.UserID;
}
public TBLNoSarfDetelsDlg(DataSources.dsRetirementCenter.TBLNoSarfDetelsRow row)
{
InitializeComponent();
_row = row;
dedatehala.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _row, "datehala", true));
tbhalarem.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _row, "halarem", true));
}
public MSWordViewerFrm(DataSources.dsQueries.QryItemsRow row)
{
InitializeComponent();
_row = row;
notify = new nsLib.Utilities.UpdateInfo();
notify.AddItem(false); notify.AddItem(false);
notify.AddItem(new int()); notify.AddItem(new int());
}
public UserEditorWFrm(DataSources.dsGM.UserRow row)
{
InitializeComponent();
_row = row;
DataBindingSource.DataSource = _row;
UserNameTextEdit.DataBindings.Add(new Binding("EditValue", _row, "UserName", true));
UserPassTextEdit.DataBindings.Add(new Binding("EditValue", _row, "UserPass", true));
}
public static short GetJobTitleId(string JobTitle, DataSources.dsData.JobTitleDataTable tbl)
{
short outPut = UnknownJobTitleId;
string FilterString = string.Format(@"JobTitle like '{0}'", JobTitle);
DataSources.dsData.JobTitleRow[] jobs = (DataSources.dsData.JobTitleRow[])tbl.Select(FilterString);
if (jobs.Length != 0)
outPut = jobs[0].JobTitleId;
return outPut;
}
public ItemEditorDLG(DataSources.dsDataCenter.ItemRow row, string filePath = "")
{
InitializeComponent();
_row = row;
if (filePath != "")
ofd.FileName = filePath;
notify = new nsLib.Utilities.UpdateInfo();
notify.AddItem(false); notify.AddItem(false);
notify.AddItem(pbc.Properties.Maximum); notify.AddItem(pbc.EditValue);
}
public ReceiptsWFrm(DataSources.dsTeachersUnion.ReceiptsRow row, bool insert, bool update, bool delete, bool FocusOnDetails = false)
{
InitializeComponent();
_row = row;
_Insert = insert;
_Update = update;
_Delete = delete;
if (FocusOnDetails)
xtraTabControl1.SelectedTabPage = xtraTabPageDetails;
}
public TblMemberAmanatW2Frm(DataSources.dsRetirementCenter.TblMemberAmanatRow row, bool insert, bool update, bool delete)
{
InitializeComponent();
_row = row;
_Insert = insert;
_Update = update;
_Delete = delete;
if (_row.RowState == DataRowState.Detached)
_row.amanattypeid = (int)Program.cd_amanattype.amanat2;
}
public ApplicationSettings(string fileName)
{
_fileName = Path.GetFullPath(fileName);
_fileFolder = Path.GetDirectoryName(_fileName);
_autoUpdate = new AutoUpdateSettings();
_mainWindow = new WindowSettings();
_dataSources = new DataSources();
_quickFilters = new QuickFilters();
}
public TBLEmpWorkWFrm(DataSources.dsTeachersUnion.TBLEmpWorkRow row)
{
InitializeComponent();
_row = row;
if (_row.RowState == DataRowState.Detached)
{
ceclosed.Checked = false;
ceclosed.Visible = false;
ceclosed.Enabled = false;
}
}
protected void DeleteAppDataSource_Click(object sender, ImageClickEventArgs e)
{
Hashtable State = (Hashtable)HttpRuntime.Cache[Session.SessionID];
Util util = new Util();
if (util.CheckSessionTimeout(State, Response, "../Default.aspx")) return;
DataSources DS = new DataSources();
string data_source_id = AppDataSources.Text.Substring(0,AppDataSources.Text.IndexOf(" ("));
DS.DeleteAppDataSource(State, data_source_id);
LoadData();
}
public static DataSources.dsData.EmployeeRow GetEmployeeRow(int EmployeeId, DataSources.dsData.EmployeeDataTable tbl)
{
DataSources.dsData.EmployeeRow row = tbl.FindByEmployeeId(EmployeeId);
if (row == null)
{
DataSources.dsData.EmployeeRow NewRow = tbl.NewEmployeeRow();
CreateDefaultEmployee(ref NewRow);
return NewRow;
}
else
return row;
}
public static void GetConditionTypeId(string ConditionType, ref DataSources.dsData.BillingDetailsRow SqlRow)
{
ConditionType = ConditionType.ToUpper();
if (ConditionType == Types.ConditionType.ZPR0.ToString())
SqlRow.ConditionTypeId = (short)Types.ConditionType.ZPR0;
else if (ConditionType == Types.ConditionType.Z001.ToString())
SqlRow.ConditionTypeId = (short)Types.ConditionType.Z001;
else if (ConditionType == Types.ConditionType.Z101.ToString())
SqlRow.ConditionTypeId = (short)Types.ConditionType.Z101;
else if (ConditionType == Types.ConditionType.R100.ToString())
SqlRow.ConditionTypeId = (short)Types.ConditionType.R100;
}
public EmployeeEditorWFrm(DataSources.dsNU.EmployeeRow row)
{
InitializeComponent();
// TODO: This line of code loads data into the 'dsNU.Area' table. You can move, or remove it, as needed.
this.areaTableAdapter.Fill(this.dsNU.Area);
// TODO: This line of code loads data into the 'dsNU.Job' table. You can move, or remove it, as needed.
this.jobTableAdapter.Fill(this.dsNU.Job);
_row = row;
employeeBindingSource.DataSource = _row;
EmployeeNameTextEdit.DataBindings.Add(new Binding("EditValue", _row, "EmployeeName", true));
JobIdGridLookUpEdit.DataBindings.Add(new Binding("EditValue", _row, "JobId", true));
AreaIdGridLookUpEdit.DataBindings.Add(new Binding("EditValue", _row, "AreaId", true));
}
public XRep10(DataSources.Linq.vTBLMembersPlusShadetKed row)
{
InitializeComponent();
appOptionsTableAdapter.Fill(dsTeachersUnionQuery1.AppOptions);
DataSources.dsTeachersUnionTableAdapters.TBLMembersTableAdapter adp = new DataSources.dsTeachersUnionTableAdapters.TBLMembersTableAdapter();
lblName.Text = row.MemberName;
lblJobtitle.Text = row.Jobtitle;
lblSyndicate.Text = row.Syndicate;
lblKideNumber.Text = row.KideNumber.ToString();
lblDate.Text = DateTime.Now.ToShortDateString();
}
public XmlDataSource(String userPath = @"C:\WarehouseDir\Users", String accessProfilePath = @"C:\WarehouseDir\AccessProfiles", String nfcTagsPath = @"C:\WarehouseDir\NfcTags")
{
DirectoryHelper.CreateDirectoryPath(userPath);
DirectoryHelper.CreateDirectoryPath(accessProfilePath);
DirectoryHelper.CreateDirectoryPath(nfcTagsPath);
UserPath = userPath;
AccessProfilePath = accessProfilePath;
NfcTagsPath = nfcTagsPath;
Name = "XML Data Source";
_type = DataSources.XMLDataSource;
}
public TblWarasaAmanatW2Frm(DataSources.dsRetirementCenter.TblWarasaAmanatRow row, bool insert, bool update, bool delete)
{
InitializeComponent();
sessionvtblWarasabank2.ConnectionString = Properties.Settings.Default.RetirementCenterConnectionString;
//LSMSTBLWarasa.KeyExpression = "AutoId";
//this.LSMSTBLWarasa.ElementType = typeof(RetirementCenter.DataSources.Linq.vtblWarasabank);
//LSMSTBLWarasa.QueryableSource = from q in dsLinq.vtblWarasabank2s where q.amanatmony > 0 select q;
_row = row;
_Insert = insert;
_Update = update;
_Delete = delete;
if (_row.RowState == DataRowState.Detached)
_row.amanattypeid = (int)Program.cd_amanattype.amanat2;
}
public static void CreateDefaultRoute(ref DataSources.dsData.RoutesRow row)
{
row.RouteName = DefaultRouteName;
row.Descriptions = row.RouteName;
row.PlantSalesDistrictId = Route.UnknownPlantSalesDistrictId;
row.Supervisor = string.Empty;
row.ASM = string.Empty;
row.RSM = string.Empty;
row.RouteBrandId = UnknownRouteBrandId;
row.RouteBrandIdOld = UnknownRouteBrandId;
row.RouteStatusId = Route.UnknownRouteStatusId;
row.datein = DataManager.defaultInstance.GetServerDatetime;
row.userin = UserManager.defaultInstance.UserInfo.UserID;
}
public static bool UpdateBulkBillingDetails(SqlCommand cmd, DataSources.dsData.BillingDetailsDataTable BulkTable)
{
bool outPut = false;
try
{
SqlBulkCopy bulkCopy = new SqlBulkCopy(cmd.Connection);
cmd.CommandTimeout = Managers.DataManager.ConnectionTimeout;
bulkCopy.BulkCopyTimeout = Managers.DataManager.ConnectionTimeout;
bulkCopy.ColumnMappings.Clear();
bulkCopy.ColumnMappings.Add("BillingDetailsId", "BillingDetailsId"); bulkCopy.ColumnMappings.Add("BillingDocument", "BillingDocument");
bulkCopy.ColumnMappings.Add("SoldToParty", "SoldToParty"); bulkCopy.ColumnMappings.Add("RouteNumber", "RouteNumber");
bulkCopy.ColumnMappings.Add("BillingDate", "BillingDate"); bulkCopy.ColumnMappings.Add("ConditionTypeId", "ConditionTypeId");
bulkCopy.ColumnMappings.Add("MaterialNumber", "MaterialNumber"); bulkCopy.ColumnMappings.Add("BillTypeId", "BillTypeId");
bulkCopy.ColumnMappings.Add("ReferenceDocumentN", "ReferenceDocumentN"); bulkCopy.ColumnMappings.Add("ActualInvoicedQuan", "ActualInvoicedQuan");
bulkCopy.ColumnMappings.Add("ConditionValue", "ConditionValue");
bulkCopy.ColumnMappings.Add("userin", "userin"); bulkCopy.ColumnMappings.Add("datein", "datein");
bulkCopy.DestinationTableName = BulkTable.TableName;
bulkCopy.BatchSize = BulkTable.Count;
//deleting data before saving new 1
var result = from row in BulkTable.AsEnumerable()
group row by row.BillingDate into grp
select new { BillingDate = grp.Key };
cmd.CommandText = "delete from BillingDetails where BillingDate = @BillingDate";
cmd.Parameters.Add(new SqlParameter("@BillingDate", SqlDbType.Date));
foreach (var item in result)
{
if (DevExpress.XtraSplashScreen.SplashScreenManager.Default.IsSplashFormVisible)
DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormDescription("Deleting Day " + item.BillingDate.ToShortDateString());
System.Windows.Forms.Application.DoEvents();
cmd.Parameters["@BillingDate"].Value = item.BillingDate;
cmd.ExecuteNonQuery();
}
//saving bulk
if (DevExpress.XtraSplashScreen.SplashScreenManager.Default.IsSplashFormVisible)
DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormDescription("Saving Data ..");
System.Windows.Forms.Application.DoEvents();
bulkCopy.WriteToServer(BulkTable);
outPut = true;
}
catch (SqlException ex)
{
Logger.Error("Error while trying to save BillingDetails Bulk - " + ex.Message, ex);
}
return outPut;
}
public static void CreateDefaultEquipment(ref DataSources.dsData.EquipmentRow row)
{
DateTime now = DataManager.defaultInstance.GetServerDatetime;
row.SerialNumber = "0000-00000";
row.Material = 0;
row.Description = string.Empty;
row.FunctionalId = Customer.UnknownCustomerId;
row.FunctionalLocation = string.Empty;
row.ValidFrom = now;
row.InventoryNo = string.Empty;
row.ConstructYear = now.Year.ToString();
row.BrandId = Product.UnknownBrandId;
row.datein = now;
row.userin = UserManager.defaultInstance.UserInfo.UserID;
}
public BillsEditorWFrm(DataSources.dsTinyData.BillsRow row)
{
InitializeComponent();
_row = row;
// TODO: This line of code loads data into the 'dsTinyData.BillTypes' table. You can move, or remove it, as needed.
this.billTypesTableAdapter.Fill(this.dsTinyData.BillTypes);
if (_row.BillTypeID == 0)
LUEBillTypeID.Enabled = true;
else
{
LUEBillTypeID.EditValue = _row.BillTypeID;
LUEBillTypeID.Enabled = false;
LUEBillTypeID_EditValueChanged(LUEBillTypeID, new EventArgs());
}
}
public void Setup(DataSources.DataSourceBase dataSource)
{
_dataSource = dataSource;
if (_dataSource.CanAdd)
viewItems.OptionsBehavior.AllowAddRows = DevExpress.Utils.DefaultBoolean.True;
else
viewItems.OptionsBehavior.AllowAddRows = DevExpress.Utils.DefaultBoolean.False;
bindingSource.AllowNew = _dataSource.CanAdd;
if (_dataSource.CanDelete)
viewItems.OptionsBehavior.AllowDeleteRows = DevExpress.Utils.DefaultBoolean.True;
else
viewItems.OptionsBehavior.AllowDeleteRows = DevExpress.Utils.DefaultBoolean.False;
viewItems.OptionsSelection.MultiSelect = _dataSource.CanDelete;
viewItems.OptionsBehavior.Editable = _dataSource.CanEdit;
}
public int Add([FromBody] Student stu)
{
ff.db <Student>().Insert(stu); //调用实体类，执行添加操作
DataSources.GetData <Student>(ff, true); //将改动的数据在redis中重新加载
return(1);
}
public static void SelectDataSource(DataSources dataSource, bool bSelectionFlag)
{
AvailableDataSources[dataSource].IsSelected = bSelectionFlag;
}
private void UCCompanyView_Load(object sender, EventArgs e)
{
DataSources.BindComBoxDataEnum(cbostatus, typeof(DataSources.EnumStatus), true); //绑定状态 启用 停用
DataSources.BindComBoxDataEnum(cbodata_sources, typeof(DataSources.EnumDataSources), true); //数据来源 自建 宇通
CommonCtrl.BindComboBoxByDictionarr(cborepair_qualification, "sys_repair_qualification", true); //维修资质
CommonCtrl.BindComboBoxByDictionarr(cbounit_properties, "sys_enterprise_property", true); //单位性质
CommonFuncCall.BindProviceComBox(cboprovince, "请选择");
DataSet ds = SelectCom();
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
MessageBoxEx.Show("查询公司失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
DataTable dt = ds.Tables[0];
cominfo = dt.Rows[0];
lblcom_code.Text = dt.Rows[0]["com_code"].ToString(); //公司编码
lblcom_name.Text = dt.Rows[0]["com_name"].ToString(); //公司全名
lblcom_short_name.Text = dt.Rows[0]["com_short_name"].ToString(); //公司简称
cborepair_qualification.SelectedValue = dt.Rows[0]["repair_qualification"].ToString(); //维修资质
cbounit_properties.SelectedValue = dt.Rows[0]["unit_properties"].ToString(); //单位性质
lbllegal_person.Text = dt.Rows[0]["legal_person"].ToString(); //法人负责人
lblcertificate_code.Text = dt.Rows[0]["certificate_code"].ToString(); //组织机构代码
lblzip_code.Text = dt.Rows[0]["zip_code"].ToString(); //邮编
cboprovince.SelectedValue = dt.Rows[0]["province"].ToString(); //省份
cbocity.SelectedValue = dt.Rows[0]["city"].ToString(); //城市
cbocounty.SelectedValue = dt.Rows[0]["county"].ToString(); //区县
lblcom_address.Text = dt.Rows[0]["com_address"].ToString(); //详细地址
lblcom_tel.Text = dt.Rows[0]["com_tel"].ToString(); //固话
lblcom_phone.Text = dt.Rows[0]["com_phone"].ToString(); //手机
lblcom_email.Text = dt.Rows[0]["com_email"].ToString(); //电子邮件
lblcom_fax.Text = dt.Rows[0]["com_fax"].ToString(); //传真
lbltax_account.Text = dt.Rows[0]["tax_account"].ToString(); //税号
lbltax_qualification.Text = dt.Rows[0]["tax_qualification"].ToString(); //纳税人资格
ckbindepen_check.Checked = dt.Rows[0]["indepen_check"].ToString() == "1" ? true : false; //独立核算 0 为否 1为是
ckbindepen_legalperson.Checked = dt.Rows[0]["indepen_legalperson"].ToString() == "1" ? true : false; //独立法人 0 为否 1为是
ckbfinancial_indepen.Checked = dt.Rows[0]["financial_indepen"].ToString() == "1" ? true : false; // 财务独立 0 为否 1为是
lblremark.Text = dt.Rows[0]["remark"].ToString();
lblcreate_by.Text = dt.Rows[0]["create_Username"].ToString();
if (!string.IsNullOrEmpty(dt.Rows[0]["create_time"].ToString()))
{
lblcreate_time.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(dt.Rows[0]["create_time"].ToString())).ToString();
}
lblupdate_by.Text = dt.Rows[0]["update_username"].ToString();
if (!string.IsNullOrEmpty(dt.Rows[0]["update_time"].ToString()))
{
lblupdate_time.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(dt.Rows[0]["update_time"].ToString())).ToString();
}
cbostatus.SelectedValue = dt.Rows[0]["status"].ToString();
cbodata_sources.SelectedValue = dt.Rows[0]["data_source"].ToString();
long time = 0;
if (!string.IsNullOrEmpty(dt.Rows[0]["work_time"].ToString()) &&
long.TryParse(dt.Rows[0]["work_time"].ToString(), out time))
{
lblwork_time.Text = Common.UtcLongToLocalDateTime(time).ToString();//上班时间
}
lblser_car_num.Text = dt.Rows[0]["ser_car_num"].ToString(); //服务车数
chkis_repair_newenergy.Checked = dt.Rows[0]["is_repair_newenergy"].ToString() == "1" ? true : false; // 是否维修新能源 0 为否 1为是
chkis_repair_ng.Checked = dt.Rows[0]["is_repair_ng"].ToString() == "1" ? true : false; // 是否维修NG车 0 为否 1为是
lblstaff_counts.Text = dt.Rows[0]["staff_counts"].ToString(); //人员总数
lblser_staff_counts.Text = dt.Rows[0]["ser_staff_counts"].ToString(); //服务人员数
lblmach_repair_staff_counts.Text = dt.Rows[0]["mach_repair_staff_counts"].ToString(); //机器人数
lblholder_electrician_counts.Text = dt.Rows[0]["holder_electrician_counts"].ToString(); //持证电工数
lbltrench_counts.Text = dt.Rows[0]["trench_counts"].ToString(); //地沟\举升机数
lbltwelve_trench_counts.Text = dt.Rows[0]["twelve_trench_counts"].ToString(); //标准地沟\举升机数
lblfour_location_counts.Text = dt.Rows[0]["four_location_counts"].ToString(); //四轮定位仪数
lblengine_test_counts.Text = dt.Rows[0]["engine_test_counts"].ToString(); //发动机检测仪数
lblfactory_area.Text = CommonUtility.DecimalRightZeroFill(dt.Rows[0]["factory_area"].ToString(), 2); //厂区占地面积
lblparking_area.Text = CommonUtility.DecimalRightZeroFill(dt.Rows[0]["parking_area"].ToString(), 2); //停车区面积
lblreception_area.Text = CommonUtility.DecimalRightZeroFill(dt.Rows[0]["reception_area"].ToString(), 2); //接待室面积
lblcust_lounge_area.Text = CommonUtility.DecimalRightZeroFill(dt.Rows[0]["cust_lounge_area"].ToString(), 2); //客户休息室面积
lblcust_toilet_area.Text = CommonUtility.DecimalRightZeroFill(dt.Rows[0]["cust_toilet_area"].ToString(), 2); //客户洗手间面积
lblmeeting_room_area.Text = CommonUtility.DecimalRightZeroFill(dt.Rows[0]["meeting_room_area"].ToString(), 2); //会议室面积
lbltraining_room_area.Text = CommonUtility.DecimalRightZeroFill(dt.Rows[0]["training_room_area"].ToString(), 2); //培训室面积
lblsettlement_area.Text = CommonUtility.DecimalRightZeroFill(dt.Rows[0]["settlement_area"].ToString(), 2); //结算区面积
lblrepaired_area.Text = CommonUtility.DecimalRightZeroFill(dt.Rows[0]["repaired_area"].ToString(), 2); //待修区面积
lblcheck_area.Text = CommonUtility.DecimalRightZeroFill(dt.Rows[0]["check_area"].ToString(), 2); //检查区面积
lblrepair_workshop_area.Text = CommonUtility.DecimalRightZeroFill(dt.Rows[0]["repair_workshop_area"].ToString(), 2); //维修车间面积
lblbig_repaired_area.Text = CommonUtility.DecimalRightZeroFill(dt.Rows[0]["big_repaired_area"].ToString(), 2); //总成大修面积
lblparts_sales_area.Text = CommonUtility.DecimalRightZeroFill(dt.Rows[0]["parts_sales_area"].ToString(), 2); //配件销售面积
lblparts_warehouse_area.Text = CommonUtility.DecimalRightZeroFill(dt.Rows[0]["parts_warehouse_area"].ToString(), 2); //配件仓库面积
lbloldparts_warehouse_area.Text = CommonUtility.DecimalRightZeroFill(dt.Rows[0]["oldparts_warehouse_area"].ToString(), 2); //旧件仓库面积
lblrepair_instructions.Text = dt.Rows[0]["repair_instructions"].ToString(); //维修说明
ArrayList al = new ArrayList();
al.Add("sys_post");//岗位
dtdic = CommonFuncCall.GetDictionariesByPDic_codes(al);
//DataTable dt_user = DBHelper.GetTable("查询公司人员信息", "v_User", "*", "com_id='" + id + "'", "", "order by create_time");
DataTable dt_user = DBHelper.GetTable("查询公司人员信息", "v_User", "*", "com_name='" + id + "'", "", "order by create_time");
if (dt_user != null)
{
dgvUser.DataSource = dt_user.DefaultView;
}
SetSysManageViewBtn();
if (dt.Rows[0]["status"].ToString() == ((int)DataSources.EnumStatus.Start).ToString())
{
btnStatus.Caption = "停用";
}
else
{
btnStatus.Caption = "启用";
}
}
/// <summary>
/// Request to initiate a real time data stream.
/// </summary>
/// <param name="request">The request</param>
/// <returns>True is the request was successful, false otherwise.</returns>
public bool RequestRealTimeData(RealTimeDataRequest request)
{
request.AssignedID = GetUniqueRequestID();
lock (_requestsLock)
{
_requests.Add(request.AssignedID, request);
}
//if there is already an active stream of this instrument
bool streamExists;
lock (_activeStreamsLock)
{
streamExists = ActiveStreams.Collection.Any(x => x.Instrument.ID == request.Instrument.ID &&
x.Frequency == request.Frequency);
}
if (streamExists)
{
IncrementSubscriberCount(request.Instrument);
//log the request
Log(LogLevel.Info,
string.Format("RTD Request for existing stream: {0} from {1} @ {2}",
request.Instrument.Symbol,
request.Instrument.Datasource.Name,
Enum.GetName(typeof(BarSize), request.Frequency)));
return(true);
}
else if (DataSources.ContainsKey(request.Instrument.Datasource.Name) && //make sure the datasource is present & connected
DataSources[request.Instrument.Datasource.Name].Connected)
{
if (request.Instrument.IsContinuousFuture)
{
//if it's a CF, we need to find which contract is currently "used"
//and request that one
int frontContractRequestID;
lock (_cfRequestLock)
{
frontContractRequestID = _cfBroker.RequestFrontContract(request.Instrument);
_pendingCFRealTimeRequests.Add(frontContractRequestID, request);
}
Log(LogLevel.Info,
string.Format("Request for CF RTD, sent front contract request, RT request ID: {0}, FC request ID: {1}",
request.AssignedID,
frontContractRequestID));
//the asynchronous nature of the request for the front month creates a lot of problems
//we either have to abandon the REP socket and use something asynchronous there
//which creates a ton of problems (we need unique IDs for every request and so forth)
//or we send back "success" without actually knowing if the request for the
//continuous futures real time data was successful or not!
//For now I have chosen the latter approach.
}
else //NOT a continuous future, just a normal instrument: do standard request procedure
{
ForwardRTDRequest(request);
}
return(true);
}
else //no new request was made, send the client the reason why
{
if (!DataSources.ContainsKey(request.Instrument.Datasource.Name))
{
throw new Exception("No such datasource.");
}
if (!DataSources[request.Instrument.Datasource.Name].Connected)
{
throw new Exception("Datasource not connected.");
}
return(false);
}
}
/// <summary>
/// 绑定处理方式值
/// </summary>
private void BindProcessMode()
{
cobProcessMode.DataSource = DataSources.EnumToList(typeof(DataSources.EnumOldSendProcessMode), true);
cobProcessMode.ValueMember = "Value";
cobProcessMode.DisplayMember = "Text";
}
public SymbolicValue(ILInstruction dataSource, VMType type)
{
DataSources.Add(dataSource);
Type = type;
}
public GamePropertiesController(ILogger <GamePropertiesController> logger, DataSources dataSources, INotification notification)
{
_logger = logger;
_dataAccess = dataSources.DataAccess;
_notification = notification;
}
/// <summary>
/// 根据旧件发货单Id获取相应的详细信息
/// </summary>
/// <param name="strRId">旧件发货单Id值</param>
private void GetRescueData(string strRId)
{
#region 基本信息
//SetBtnStatus(WindowStatus.View);
DataTable dt = DBHelper.GetTable("旧件发货单预览", "tb_maintain_oldpart_receiv_send", "*", string.Format(" oldpart_id='{0}'", strRId), "", "");
if (dt.Rows.Count > 0)
{
#region 维修表信息
DataRow dr = dt.Rows[0];
if (!string.IsNullOrEmpty(CommonCtrl.IsNullToString(dr["receipts_no"])))
{
labMaterialNoS.Text = CommonCtrl.IsNullToString(dr["receipts_no"]);//发货单号
}
else
{
labMaterialNoS.Text = string.Empty;
}
labCustomNOS.Text = CommonCtrl.IsNullToString(dr["customer_code"]); //客户编码
labCustomNameS.Text = CommonCtrl.IsNullToString(dr["customer_name"]); //客户名称
labContactS.Text = CommonCtrl.IsNullToString(dr["linkman"]); //联系人
labContactPhoneS.Text = CommonCtrl.IsNullToString(dr["link_man_mobile"]); //联系人电话
string strRTime = CommonCtrl.IsNullToString(dr["receipt_time"]); //发货日期
if (!string.IsNullOrEmpty(strRTime))
{
labReceiptTimeS.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(strRTime)).ToString("yyyy-MM-dd HH:mm");
}
else
{
labReceiptTimeS.Text = string.Empty;
}
labRemarkS.Text = CommonCtrl.IsNullToString(dr["remarks"]); //备注
labStatusS.Text = DataSources.GetDescription(typeof(DataSources.EnumAuditStatus), int.Parse(CommonCtrl.IsNullToString(dr["info_status"]))); //单据状态
labDepartS.Text = GetDepartmentName(CommonCtrl.IsNullToString(dr["org_name"])); //部门
labAttnS.Text = GetUserSetName(CommonCtrl.IsNullToString(dr["responsible_name"])); //经办人
labCreatePersonS.Text = CommonCtrl.IsNullToString(dr["create_name"]); //创建人
string strCreateTime = CommonCtrl.IsNullToString(dr["create_time"]); //创建时间
if (!string.IsNullOrEmpty(strCreateTime))
{
labCreateTimeS.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(strCreateTime)).ToString("yyyy-MM-dd HH:mm");
}
else
{
labCreateTimeS.Text = string.Empty;
}
labFinallyPerS.Text = CommonCtrl.IsNullToString(dr["update_name"]); //最后编辑人
string strFinallyTime = CommonCtrl.IsNullToString(dr["update_time"]); //最后编辑时间
if (!string.IsNullOrEmpty(strFinallyTime))
{
labFinallyTimeS.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(strFinallyTime)).ToString("yyyy-MM-dd HH:mm");
}
else
{
labFinallyTimeS.Text = string.Empty;
}
strStatus = CommonCtrl.IsNullToString(dr["info_status"]);//单据状态
if (strStatus == Convert.ToInt32(DataSources.EnumAuditStatus.SUBMIT).ToString())
{
//已提交状态屏蔽提交、编辑、删除按钮
base.btnSubmit.Enabled = false;
base.btnEdit.Enabled = false;
base.btnDelete.Enabled = false;
base.btnActivation.Enabled = false;
}
else if (strStatus == Convert.ToInt32(DataSources.EnumAuditStatus.AUDIT).ToString())
{
//已审核时屏蔽提交、审核、编辑、删除按钮
base.btnSubmit.Enabled = false;
base.btnVerify.Enabled = false;
base.btnEdit.Enabled = false;
base.btnDelete.Enabled = false;
base.btnActivation.Enabled = false;
}
else if (strStatus == Convert.ToInt32(DataSources.EnumAuditStatus.NOTAUDIT).ToString() || strStatus == Convert.ToInt32(DataSources.EnumAuditStatus.DRAFT).ToString())
{
//审核没通过时屏蔽审核按钮
base.btnVerify.Enabled = false;
}
else if (strStatus == Convert.ToInt32(DataSources.EnumAuditStatus.Invalid).ToString())
{
base.btnActivation.Caption = "激活";
base.btnSubmit.Enabled = false;
base.btnVerify.Enabled = false;
base.btnEdit.Enabled = false;
}
#endregion
#endregion
#region 配件信息
DataTable dpt = DBHelper.GetTable("旧件发货单详情", "tb_maintain_oldpart_material_detail", "*", string.Format(" maintain_id='{0}'", strRId), "", "");
dgvMaterials.DataSource = dpt;
#endregion
}
else
{
#region 没有数据时全部显示为空
labContactPhoneS.Text = string.Empty;
labContactS.Text = string.Empty;
labCreatePersonS.Text = string.Empty;
labCreateTimeS.Text = string.Empty;
labCustomNameS.Text = string.Empty;
labCustomNOS.Text = string.Empty;
labDepartS.Text = string.Empty;
labFinallyPerS.Text = string.Empty;
labFinallyTimeS.Text = string.Empty;
labStatusS.Text = string.Empty;
labRemarkS.Text = string.Empty;
#endregion
}
}
//绑定数据
public void BindData()
{
StringBuilder sbWhere = new StringBuilder();//条件
sbWhere.AppendFormat(" create_time between {0} and {1}", Common.LocalDateTimeToUtcLong(DateTime.Parse(diCreate.StartDate).Date),
Common.LocalDateTimeToUtcLong(DateTime.Parse(diCreate.EndDate).Date.AddDays(1).AddMilliseconds(-1)));
sbWhere.AppendFormat(" and enable_flag='{0}'", (int)DataSources.EnumEnableFlag.USING); //标识未删除
string name = txtContName.Caption.Trim(); //联系人名
if (name.Length > 0)
{
sbWhere.AppendFormat(" and cont_name like '%{0}%'", name);
}
string post = CommonCtrl.IsNullToString(cboContPost.SelectedValue);//职务
if (post.Length > 0)
{
sbWhere.AppendFormat(" and cont_post='{0}'", post);
}
//string isDefault = CommonCtrl.IsNullToString(cboDefault.SelectedValue);//是否默认
//if (isDefault.Length > 0)
//{
// sbWhere.AppendFormat(" and is_default='{0}'", isDefault);
//}
string sex = CommonCtrl.IsNullToString(cboSex.SelectedValue);//性别
if (sex.Length > 0)
{
sbWhere.AppendFormat(" and sex='{0}'", sex);
}
string dataSource = CommonCtrl.IsNullToString(cboDataSources.SelectedValue);//数据来源
if (dataSource.Length > 0)
{
sbWhere.AppendFormat(" and data_source='{0}'", dataSource);
}
string status = CommonCtrl.IsNullToString(cboStatus.SelectedValue);//状态
if (status.Length > 0)
{
sbWhere.AppendFormat(" and status='{0}'", status);
}
string dianhua = txtDianHua.Caption.Trim();//电话
if (dianhua.Length > 0)
{
//sbWhere.AppendFormat(" and (cont_phone like '%{0}%' or cont_tel like '%{0}%')", dianhua);
sbWhere.AppendFormat(" and ({1} like '%{0}%' or {2} like '%{0}%')", dianhua, EncryptByDB.GetDesFieldValue("cont_phone"), EncryptByDB.GetDesFieldValue("cont_tel"));
}
string relation = CommonCtrl.IsNullToString(cboAffiliation.SelectedValue);//归属类型
switch (relation)
{
case "1":
sbWhere.AppendFormat(" and isnull(cust_count,0)>0"); //客户类型
break;
case "2":
sbWhere.AppendFormat(" and isnull(vehi_count,0)>0"); //车辆类型
break;
case "3":
sbWhere.AppendFormat(" and isnull(supp_count,0)>0"); //供应商类型
break;
}
int recordCount;//总数量
DataTable dt = DBHelper.GetTableByPage("联系人查询", "v_contacts", string.Format("*,{0} phone,{1} tel", EncryptByDB.GetDesFieldValue("cont_phone"), EncryptByDB.GetDesFieldValue("cont_tel")), sbWhere.ToString(), "", "order by create_time desc", page.PageIndex, page.PageSize, out recordCount);
dgvContacts.RowCount = 0;
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
DataGridViewRow dgvr = dgvContacts.Rows[dgvContacts.Rows.Add()];
dgvr.Cells["colContID"].Value = dr["cont_id"];
dgvr.Cells["colContName"].Value = dr["cont_name"];
string sexName = CommonCtrl.IsNullToString(dr["sex"]);
if (sexName == "1")
{
dgvr.Cells["colSex"].Value = "男";
}
else if (sexName == "0")
{
dgvr.Cells["colSex"].Value = "女";
}
dgvr.Cells["colContPost"].Value = dr["cont_post_name"];
dgvr.Cells["colNation"].Value = dr["nation_name"];
dgvr.Cells["colContPhone"].Value = dr["phone"];
dgvr.Cells["colContTel"].Value = dr["tel"];
//string isdefault = CommonCtrl.IsNullToString(dr["is_default"]);
//dgvr.Cells["colIsDefault"].Value = isdefault == "1" ? "是" : "否";
string relationName = string.Empty;//归属类型
if (CommonCtrl.IsNullToString(dr["cust_count"]).Length > 0)
{
relationName = "客户联系人";
}
if (CommonCtrl.IsNullToString(dr["vehi_count"]).Length > 0)
{
if (relationName.Length > 0)
{
relationName += ",";
}
relationName += "车辆联系人";
}
if (CommonCtrl.IsNullToString(dr["supp_count"]).Length > 0)
{
if (relationName.Length > 0)
{
relationName += ",";
}
relationName += "供应商联系人";
}
//dgvr.Cells["colAffiliation"].Value = relationName;
dgvr.Cells["colDataSources"].Value = DataSources.GetDescription(typeof(DataSources.EnumDataSources), dr["data_source"]);
dgvr.Cells[colDataSources.Name].Tag = dr["data_source"];
string createTime = CommonCtrl.IsNullToString(dr["create_time"]);
if (createTime.Length > 0)
{
dgvr.Cells["colCreateTime"].Value = Common.UtcLongToLocalDateTime(Convert.ToInt64(createTime));
}
//dgvr.Cells[colStatus.Name].Value = dr["status"];
dgvr.Cells[colStatus.Name].Value = DataSources.GetDescription(typeof(DataSources.EnumStatus), dr["status"]);
dgvr.Cells[colStatus.Name].Tag = dr["status"];
}
page.RecordCount = recordCount;
page.SetBtnState();
}
}
public object Get()
{
var data = DataSources.GetData <Student>(ff);
return(new { data = data, code = 0 });
}
public void SetShapeDescriptor(DataSources dataSource, ShapeDescriptor shapeDescriptor)
{
short transferMode;
switch (dataSource)
{
case DataSources.Primary:
if (shapeDescriptor.Equals(NativeObject.Primary.Texture))
{
// Texture is not different, so exit
return;
}
NativeObject.Primary.Texture = shapeDescriptor;
transferMode = NativeObject.PrimaryTransferMode;
break;
case DataSources.Secondary:
if (shapeDescriptor.Equals(NativeObject.Secondary.Texture))
{
// Texture is not different, so exit
return;
}
NativeObject.Secondary.Texture = shapeDescriptor;
transferMode = NativeObject.SecondaryTransferMode;
break;
case DataSources.Transparent:
if (shapeDescriptor.Equals(NativeObject.Transparent.Texture))
{
// Texture is not different, so exit
return;
}
NativeObject.Transparent.Texture = shapeDescriptor;
transferMode = NativeObject.TransparentTransferMode;
break;
default:
return;
}
short newTransferMode = 0;
if (shapeDescriptor.UsesLandscapeCollection())
{
newTransferMode = 9;
}
else if (transferMode != 9)
{
newTransferMode = transferMode;
}
switch (dataSource)
{
case LevelEntity_Side.DataSources.Primary:
NativeObject.PrimaryTransferMode = newTransferMode;
PrimarySurface.ApplyTexture();
break;
case LevelEntity_Side.DataSources.Secondary:
NativeObject.SecondaryTransferMode = newTransferMode;
SecondarySurface.ApplyTexture();
break;
case LevelEntity_Side.DataSources.Transparent:
NativeObject.TransparentTransferMode = newTransferMode;
TransparentSurface.ApplyTexture(innerLayer: !NativeObject.HasLayeredTransparentSide(ParentLevel.Level));
break;
}
}
/// <summary>
/// 根据预约单Id获取相应的详细信息
/// </summary>
/// <param name="strRId">预约单reserv_id值</param>
private void GetReservData(string strRId)
{
#region 基本信息
//SetBtnStatus(WindowStatus.View);
DataTable dt = DBHelper.GetTable("预约单预览", "tb_maintain_reservation", "*", string.Format(" reserv_id='{0}'", strRId), "", "");
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
if (!string.IsNullOrEmpty(CommonCtrl.IsNullToString(dr["reservation_no"])))
{
labReserveNoS.Text = CommonCtrl.IsNullToString(dr["reservation_no"]);//预约单号
}
else
{
labReserveNoS.Text = string.Empty;
}
string strReTime = CommonCtrl.IsNullToString(dr["reservation_date"]);//预约日期
if (!string.IsNullOrEmpty(strReTime))
{
labReTimeS.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(strReTime)).ToString("yyyy-MM-dd HH:mm");
}
else
{
labReTimeS.Text = string.Empty;
}
string strInTime = CommonCtrl.IsNullToString(dr["maintain_time"]);//预约进场日期
if (!string.IsNullOrEmpty(strInTime))
{
labInTimeS.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(strInTime)).ToString("yyyy-MM-dd HH:mm");
}
else
{
labInTimeS.Text = string.Empty;
}
labRepPersonS.Text = CommonCtrl.IsNullToString(dr["reservation_man"]); //预约人
labRepPersonPhoneS.Text = CommonCtrl.IsNullToString(dr["reservation_mobile"]); //预约人手机
labYesS.Text = CommonCtrl.IsNullToString(dr["whether_greet"]) == "1"?"是":"否"; //是否接车
labAddressS.Text = CommonCtrl.IsNullToString(dr["greet_site"]); //接车地址
labDescS.Text = CommonCtrl.IsNullToString(dr["fault_describe"]); //故障描述
labCustomNOS.Text = CommonCtrl.IsNullToString(dr["customer_code"]); //客户编码
labCustomNameS.Text = CommonCtrl.IsNullToString(dr["customer_name"]); //客户名称
labCarNOS.Text = CommonCtrl.IsNullToString(dr["vehicle_no"]); //车牌号
labCarTypeS.Text = GetVmodel(CommonCtrl.IsNullToString(dr["vehicle_model"])); //车型
labCarBrandS.Text = GetDicName(CommonCtrl.IsNullToString(dr["vehicle_brand"])); //车辆品牌
labVINS.Text = CommonCtrl.IsNullToString(dr["vehicle_vin"]); //VIN
labEngineNoS.Text = CommonCtrl.IsNullToString(dr["engine_type"]); //发动机号
labColorS.Text = GetDicName(CommonCtrl.IsNullToString(dr["vehicle_color"])); //颜色
labRepTypeS.Text = GetDicName(CommonCtrl.IsNullToString(dr["maintain_type"])); //维修类别
labPayTypeS.Text = GetDicName(CommonCtrl.IsNullToString(dr["maintain_payment"])); //维修付费方式
labContactS.Text = CommonCtrl.IsNullToString(dr["linkman"]); //联系人
labContactPhoneS.Text = CommonCtrl.IsNullToString(dr["link_man_mobile"]); //联系人手机
labRemarkS.Text = CommonCtrl.IsNullToString(dr["remark"]); //备注
labStatusS.Text = DataSources.GetDescription(typeof(DataSources.EnumAuditStatus), int.Parse(CommonCtrl.IsNullToString(dr["document_status"]))); //单据状态
//labMoney.Text = CommonCtrl.IsNullToString(dr["maintain_payment"]);//欠款余额
labDepartS.Text = GetDepartmentName(CommonCtrl.IsNullToString(dr["org_name"])); //部门
labAttnS.Text = GetUserSetName(CommonCtrl.IsNullToString(dr["responsible_opid"])); //经办人
labCreatePersonS.Text = CommonCtrl.IsNullToString(dr["create_name"]); //创建人
string strCreateTime = CommonCtrl.IsNullToString(dr["create_time"]); //创建时间
if (!string.IsNullOrEmpty(strCreateTime))
{
labCreateTimeS.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(strCreateTime)).ToString("yyyy-MM-dd HH:mm");
}
else
{
labCreateTimeS.Text = string.Empty;
}
labFinallyPerS.Text = CommonCtrl.IsNullToString(dr["update_name"]); //最后编辑人
string strFinallyTime = CommonCtrl.IsNullToString(dr["update_time"]); //最后编辑时间
if (!string.IsNullOrEmpty(strFinallyTime))
{
labFinallyTimeS.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(strFinallyTime)).ToString("yyyy-MM-dd HH:mm");
}
else
{
labFinallyTimeS.Text = string.Empty;
}
strStatus = CommonCtrl.IsNullToString(dr["document_status"]);//单据状态
if (strStatus == Convert.ToInt32(DataSources.EnumAuditStatus.SUBMIT).ToString())
{
//已提交状态屏蔽提交、编辑、删除按钮
base.btnSubmit.Enabled = false;
base.btnEdit.Enabled = false;
base.btnDelete.Enabled = false;
base.btnActivation.Enabled = false;
}
else if (strStatus == Convert.ToInt32(DataSources.EnumAuditStatus.AUDIT).ToString())
{
//已审核时屏蔽提交、审核、编辑、删除按钮
base.btnSubmit.Enabled = false;
base.btnVerify.Enabled = false;
base.btnEdit.Enabled = false;
base.btnDelete.Enabled = false;
base.btnActivation.Enabled = false;
}
else if (strStatus == Convert.ToInt32(DataSources.EnumAuditStatus.NOTAUDIT).ToString() || strStatus == Convert.ToInt32(DataSources.EnumAuditStatus.DRAFT).ToString())
{
//审核没通过时屏蔽审核按钮
base.btnVerify.Enabled = false;
}
else if (strStatus == Convert.ToInt32(DataSources.EnumAuditStatus.Invalid).ToString())
{
base.btnActivation.Caption = "激活";
base.btnSubmit.Enabled = false;
base.btnVerify.Enabled = false;
base.btnEdit.Enabled = false;
}
#endregion
#region 底部datagridview数据
#region 维修项目数据
//维修项目数据
DataTable dpt = DBHelper.GetTable("维修项目数据", "tb_maintain_item", "*", string.Format(" maintain_id='{0}' and enable_flag='" + Convert.ToInt32(DataSources.EnumEnableFlag.USING).ToString() + "'", strRId), "", "");
if (dpt.Rows.Count > 0)
{
if (dpt.Rows.Count > dgvproject.Rows.Count)
{
dgvproject.Rows.Add(dpt.Rows.Count - dgvproject.Rows.Count + 1);
}
for (int i = 0; i < dpt.Rows.Count; i++)
{
DataRow dpr = dpt.Rows[i];
dgvproject.Rows[i].Cells["item_id"].Value = CommonCtrl.IsNullToString(dpr["item_id"]);
dgvproject.Rows[i].Cells["three_warranty"].Value = CommonCtrl.IsNullToString(dpr["three_warranty"]) == "1" ? "是" : "否";
dgvproject.Rows[i].Cells["man_hour_type"].Value = CommonCtrl.IsNullToString(dpr["man_hour_type"]);
dgvproject.Rows[i].Cells["item_no"].Value = CommonCtrl.IsNullToString(dpr["item_no"]);
dgvproject.Rows[i].Cells["item_name"].Value = CommonCtrl.IsNullToString(dpr["item_name"]);
dgvproject.Rows[i].Cells["item_type"].Value = CommonCtrl.IsNullToString(dpr["item_type"]);
dgvproject.Rows[i].Cells["man_hour_quantity"].Value = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dpr["man_hour_quantity"]), 1);
dgvproject.Rows[i].Cells["man_hour_norm_unitprice"].Value = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dpr["man_hour_norm_unitprice"]), 2);
dgvproject.Rows[i].Cells["remarks"].Value = CommonCtrl.IsNullToString(dpr["remarks"]);
dgvproject.Rows[i].Cells["sum_money"].Value = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dpr["sum_money"]), 2);
}
}
#endregion
#region 维修用料数据
//维修用料数据
DataTable dmt = DBHelper.GetTable("维修用料数据", "tb_maintain_material_detail", "*", string.Format(" maintain_id='{0}' and enable_flag='" + Convert.ToInt32(DataSources.EnumEnableFlag.USING).ToString() + "'", strRId), "", "");
if (dmt.Rows.Count > 0)
{
if (dmt.Rows.Count > dgvMaterials.Rows.Count)
{
dgvMaterials.Rows.Add(dmt.Rows.Count - dgvMaterials.Rows.Count + 1);
}
for (int i = 0; i < dmt.Rows.Count; i++)
{
DataRow dmr = dmt.Rows[i];
dgvMaterials.Rows[i].Cells["material_id"].Value = CommonCtrl.IsNullToString(dmr["material_id"]);
dgvMaterials.Rows[i].Cells["parts_code"].Value = CommonCtrl.IsNullToString(dmr["parts_code"]);
dgvMaterials.Rows[i].Cells["parts_name"].Value = CommonCtrl.IsNullToString(dmr["parts_name"]);
dgvMaterials.Rows[i].Cells["norms"].Value = CommonCtrl.IsNullToString(dmr["norms"]);
dgvMaterials.Rows[i].Cells["unit"].Value = CommonCtrl.IsNullToString(dmr["unit"]);
dgvMaterials.Rows[i].Cells["quantity"].Value = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dmr["quantity"]), 1);
dgvMaterials.Rows[i].Cells["unit_price"].Value = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dmr["unit_price"]), 2);
dgvMaterials.Rows[i].Cells["Msum_money"].Value = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dmr["sum_money"]), 2);
dgvMaterials.Rows[i].Cells["drawn_no"].Value = CommonCtrl.IsNullToString(dmr["drawn_no"]);
dgvMaterials.Rows[i].Cells["vehicle_model"].Value = CommonCtrl.IsNullToString(dmr["vehicle_model"]);
dgvMaterials.Rows[i].Cells["Mthree_warranty"].Value = CommonCtrl.IsNullToString(dmr["three_warranty"]) == "1" ? "是" : "否";
dgvMaterials.Rows[i].Cells["Mremarks"].Value = CommonCtrl.IsNullToString(dmr["remarks"]);
dgvMaterials.Rows[i].Cells["whether_imported"].Value = CommonCtrl.IsNullToString(dmr["whether_imported"]) == "1" ? "是" : "否";
}
}
#endregion
#endregion
}
else
{
#region 置空
labAddressS.Text = string.Empty;
labAttnS.Text = string.Empty;
labCarBrandS.Text = string.Empty;
labCarNOS.Text = string.Empty;
labCarTypeS.Text = string.Empty;
labColorS.Text = string.Empty;
labContactPhoneS.Text = string.Empty;
labContactS.Text = string.Empty;
labCreatePersonS.Text = string.Empty;
labCreateTimeS.Text = string.Empty;
labCustomNameS.Text = string.Empty;
labCustomNOS.Text = string.Empty;
labDepartS.Text = string.Empty;
labDescS.Text = string.Empty;
labMoney.Text = "0.00";
labEngineNoS.Text = string.Empty;
labFinallyPerS.Text = string.Empty;
labFinallyTimeS.Text = string.Empty;
labInTimeS.Text = string.Empty;
labPayTypeS.Text = string.Empty;
labRemarkS.Text = string.Empty;
labRepPersonPhoneS.Text = string.Empty;
labRepPersonS.Text = string.Empty;
labRepTypeS.Text = string.Empty;
labReserveNoS.Text = string.Empty;
labReTimeS.Text = string.Empty;
labStatusS.Text = string.Empty;
labVINS.Text = string.Empty;
labYesS.Text = string.Empty;
#endregion
}
}
/// 绑定单据状态
/// </summary>
private void BindOrderStatus()
{
cobOrderStatus.DataSource = DataSources.EnumToList(typeof(DataSources.EnumAuditStatus), true);
cobOrderStatus.ValueMember = "Value";
cobOrderStatus.DisplayMember = "Text";
}
/// <summary>
/// 添加情况下组装sql的方法
/// </summary>
/// <param name="listSql"></param>
/// <param name="purchase_billing_id"></param>
private void AddAllotBillSql(List <SysSQLString> listSql, tb_parts_stock_allot AllotEntity, string StockAllotId, string HandleType)
{
try
{
const string NoDelFlag = "1"; //默认删除标记1表示未删除，0表示删除
string Save = DataSources.GetDescription(DataSources.EnumOperateType.save, true); //保存操作
string Submit = DataSources.GetDescription(DataSources.EnumOperateType.submit, true); //提交操作
//SQL语句拼装操作
SysSQLString sysStringSql = new SysSQLString();
sysStringSql.cmdType = CommandType.Text;
Dictionary <string, string> dicParam = new Dictionary <string, string>();//保存SQL语句参数值
CommonFuncCall.FillEntityByControls(this, AllotEntity);
AllotEntity.stock_allot_id = StockAllotId;
AllotEntity.update_by = GlobalStaticObj.UserID;
AllotEntity.operators = GlobalStaticObj.UserID;
AllotEntity.enable_flag = NoDelFlag;
if (HandleType == Save)
{
AllotEntity.order_status = Convert.ToInt32(DataSources.EnumAuditStatus.DRAFT).ToString();
AllotEntity.order_status_name = DataSources.GetDescription(DataSources.EnumAuditStatus.DRAFT, true);
}
else if (HandleType == Submit)
{
AllotEntity.order_status = Convert.ToInt32(DataSources.EnumAuditStatus.SUBMIT).ToString();
AllotEntity.order_status_name = DataSources.GetDescription(DataSources.EnumAuditStatus.SUBMIT, true);
}
if (AllotEntity != null)
{
long CurrentDate = Common.LocalDateTimeToUtcLong(Convert.ToDateTime(DateTime.Now.ToShortDateString()));
StringBuilder sb = new StringBuilder();
sb.Append(" Insert Into " + AllotBillTable + "( ");
StringBuilder sb_PrValue = new StringBuilder();
StringBuilder sb_PrName = new StringBuilder();
foreach (PropertyInfo info in AllotEntity.GetType().GetProperties())
{
string name = info.Name;
object value = info.GetValue(AllotEntity, null);
sb_PrName.Append("," + name); //数据表字段名
sb_PrValue.Append(",@" + name); //数据表字段值
if (name == "create_time")
{
dicParam.Add(name, CurrentDate.ToString());//添加创建时间
}
else
{
dicParam.Add(name, value == null ? "" : value.ToString());
}
}
sb.Append(sb_PrName.ToString().Substring(1, sb_PrName.ToString().Length - 1) + ") Values ("); //追加字段名
sb.Append(sb_PrValue.ToString().Substring(1, sb_PrValue.ToString().Length - 1) + ");"); //追加字段值
//完成SQL语句的拼装
sysStringSql.sqlString = sb.ToString();
sysStringSql.Param = dicParam;
listSql.Add(sysStringSql);
}
}
catch (Exception ex)
{
MessageBoxEx.Show(ex.Message, "异常提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
}
}
/// <summary>
/// 根据宇通旧件返厂单Id获取相应的详细信息
/// </summary>
/// <param name="strRId">宇通旧件返厂单Id值</param>
private void GetRescueData(string strRId)
{
#region 基本信息
//SetBtnStatus(WindowStatus.View);
DataTable dt = DBHelper.GetTable("宇通旧件返厂单预览", "tb_maintain_oldpart_recycle", "*", string.Format(" return_id='{0}'", strRId), "", "");
if (dt.Rows.Count > 0)
{
#region 维修表信息
DataRow dr = dt.Rows[0];
if (!string.IsNullOrEmpty(CommonCtrl.IsNullToString(dr["receipts_no"])))
{
labMaterialNoS.Text = CommonCtrl.IsNullToString(dr["receipts_no"]);//返厂单号
}
else
{
labMaterialNoS.Text = string.Empty;
}
string strCreateTime = CommonCtrl.IsNullToString(dr["receipt_time"]); //制单日期
if (!string.IsNullOrEmpty(strCreateTime))
{
labCreateTimeS.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(strCreateTime)).ToString("yyyy-MM-dd HH:mm");
}
else
{
labCreateTimeS.Text = string.Empty;
}
labStatusS.Text = DataSources.GetDescription(typeof(DataSources.EnumAuditStatus), int.Parse(CommonCtrl.IsNullToString(dr["info_status"]))); //单据状态
labYTStatusS.Text = GetDicName(CommonCtrl.IsNullToString(dr["info_status_yt"])); //宇通旧件回收单状态
//创建日期范围
string strSTime = CommonCtrl.IsNullToString(dr["receipt_time"]); //创建开始时间
if (!string.IsNullOrEmpty(strSTime))
{
strSTime = Common.UtcLongToLocalDateTime(Convert.ToInt64(strSTime)).ToString("yyyy-MM-dd");
}
else
{
strSTime = string.Empty;
}
string strETime = CommonCtrl.IsNullToString(dr["receipt_time"]); //创建结束时间
if (!string.IsNullOrEmpty(strETime))
{
strETime = Common.UtcLongToLocalDateTime(Convert.ToInt64(strETime)).ToString("yyyy-MM-dd");
}
else
{
strETime = string.Empty;
}
labTimeS.Text = strSTime + "-" + strETime;
labRemarkS.Text = CommonCtrl.IsNullToString(dr["remarks"]); //备注
laboldpart_receipts_no.Text = CommonCtrl.IsNullToString(dr["oldpart_receipts_no"]); //旧件回收单号
labservice_station_code.Text = CommonCtrl.IsNullToString(dr["service_station_code"]); //服务站编码
labservice_station_name.Text = CommonCtrl.IsNullToString(dr["service_station_name"]); //服务站名称
string strCTime = CommonCtrl.IsNullToString(dr["create_time_yt"]); //创建时间
if (!string.IsNullOrEmpty(strCTime))
{
labcreate_time.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(strCTime)).ToString("yyyy-MM-dd HH:mm");
}
else
{
labcreate_time.Text = string.Empty;
}
string strdepot_time = CommonCtrl.IsNullToString(dr["receipt_time"]); //回厂时间
if (!string.IsNullOrEmpty(strdepot_time))
{
labdepot_time.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(strdepot_time)).ToString("yyyy-MM-dd HH:mm");
}
else
{
labdepot_time.Text = string.Empty;
}
string strnotarize_time = CommonCtrl.IsNullToString(dr["notarize_time"]); //确认时间
if (!string.IsNullOrEmpty(strnotarize_time))
{
labnotarize_time.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(strnotarize_time)).ToString("yyyy-MM-dd HH:mm");
}
else
{
labnotarize_time.Text = string.Empty;
}
labsum_money.Text = CommonCtrl.IsNullToString(dr["sum_money"]); //旧件回收费用
labDepartS.Text = GetDepartmentName(CommonCtrl.IsNullToString(dr["org_name"])); //部门
labAttnS.Text = GetUserSetName(CommonCtrl.IsNullToString(dr["responsible_name"])); //经办人
labCreatePersonS.Text = CommonCtrl.IsNullToString(dr["create_name"]); //创建人
labFinallyPerS.Text = CommonCtrl.IsNullToString(dr["update_name"]); //最后编辑人
string strFinallyTime = CommonCtrl.IsNullToString(dr["update_time"]); //最后编辑时间
if (!string.IsNullOrEmpty(strFinallyTime))
{
labFinallyTimeS.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(strFinallyTime)).ToString("yyyy-MM-dd HH:mm");
}
else
{
labFinallyTimeS.Text = string.Empty;
}
long tickeS = Convert.ToInt64(CommonCtrl.IsNullToString(dr["create_time_start"]));
long tickeE = Convert.ToInt64(CommonCtrl.IsNullToString(dr["create_time_end"]));
strHSTime = Common.UtcLongToLocalDateTime(tickeS).ToString("yyyy-MM-dd");
strHETime = Common.UtcLongToLocalDateTime(tickeE).ToString("yyyy-MM-dd");
strStatus = CommonCtrl.IsNullToString(dr["info_status"]);//单据状态
if (strStatus == Convert.ToInt32(DataSources.EnumAuditStatus.SUBMIT).ToString())
{
//已提交状态屏蔽提交、编辑、删除按钮
base.btnSubmit.Enabled = false;
base.btnEdit.Enabled = false;
base.btnDelete.Enabled = false;
base.btnActivation.Enabled = false;
}
else if (strStatus == Convert.ToInt32(DataSources.EnumAuditStatus.AUDIT).ToString())
{
//已审核时屏蔽提交、审核、编辑、删除按钮
base.btnSubmit.Enabled = false;
base.btnVerify.Enabled = false;
base.btnEdit.Enabled = false;
base.btnDelete.Enabled = false;
base.btnActivation.Enabled = false;
}
else if (strStatus == Convert.ToInt32(DataSources.EnumAuditStatus.NOTAUDIT).ToString() || strStatus == Convert.ToInt32(DataSources.EnumAuditStatus.DRAFT).ToString())
{
//审核没通过时屏蔽审核按钮
base.btnVerify.Enabled = false;
}
else if (strStatus == Convert.ToInt32(DataSources.EnumAuditStatus.Invalid).ToString())
{
base.btnActivation.Caption = "激活";
base.btnSubmit.Enabled = false;
base.btnVerify.Enabled = false;
base.btnEdit.Enabled = false;
}
#endregion
#endregion
#region 配件信息
DataTable dpt = DBHelper.GetTable("宇通旧件返厂单详情", "tb_maintain_oldpart_recycle_material_detail", "*", string.Format(" maintain_id='{0}'", strRId), "", "");
if (dpt.Rows.Count > 0)
{
dgvMaterials.DataSource = dpt;
intDetailCount = dpt.Rows.Count;
}
#endregion
}
else
{
#region 没有数据时全部显示为空
labCreatePersonS.Text = string.Empty;
labCreateTimeS.Text = string.Empty;
labDepartS.Text = string.Empty;
labFinallyPerS.Text = string.Empty;
labFinallyTimeS.Text = string.Empty;
labStatusS.Text = string.Empty;
labRemarkS.Text = string.Empty;
#endregion
}
}
/// <summary>
/// 编辑情况下组装sql的方法
/// </summary>
/// <param name="listSql"></param>
/// <param name="purchase_billing_id"></param>
/// <param name="model"></param>
private void EditAllotBillSql(List <SysSQLString> listSql, tb_parts_stock_allot AllotEntity, string AllotBillIdValue, string HandleType)
{
try
{
const string NoDelFlag = "1"; //默认删除标记，1表示未删除，0表示删除
string Save = DataSources.GetDescription(DataSources.EnumOperateType.save, true); //保存操作
string Submit = DataSources.GetDescription(DataSources.EnumOperateType.submit, true); //提交操作
SysSQLString sysStrSql = new SysSQLString();
sysStrSql.cmdType = CommandType.Text; //sql字符串语句执行函数
Dictionary <string, string> dicParam = new Dictionary <string, string>(); //参数
CommonFuncCall.FillEntityByControls(this, AllotBillEntity);
AllotEntity.handle = GlobalStaticObj.UserID;
AllotEntity.operators = GlobalStaticObj.UserID;
AllotEntity.enable_flag = NoDelFlag;
if (HandleType == Save)
{
AllotEntity.order_status = Convert.ToInt32(DataSources.EnumAuditStatus.DRAFT).ToString();
AllotEntity.order_status_name = DataSources.GetDescription(DataSources.EnumAuditStatus.DRAFT, true);
}
else if (HandleType == Submit)
{
AllotEntity.order_status = Convert.ToInt32(DataSources.EnumAuditStatus.SUBMIT).ToString();
AllotEntity.order_status_name = DataSources.GetDescription(DataSources.EnumAuditStatus.SUBMIT, true);
}
if (AllotBillEntity != null)
{
long CurrentDate = Common.LocalDateTimeToUtcLong(Convert.ToDateTime(DateTime.Now.ToShortDateString()));
StringBuilder sb = new StringBuilder();
sb.Append(" Update " + AllotBillTable + " Set ");
bool isFirstValue = true;
foreach (PropertyInfo info in AllotEntity.GetType().GetProperties())
{
string name = info.Name;
object value = info.GetValue(AllotEntity, null);
if (isFirstValue)
{
isFirstValue = false;
sb.Append(name);
sb.Append("=");
sb.Append("@" + name);
}
else
{
sb.Append("," + name);
sb.Append("=");
sb.Append("@" + name);
}
if (name == "update_time")
{
dicParam.Add(name, CurrentDate.ToString());//添加更新时间
}
else
{
dicParam.Add(name, value == null ? "" : value.ToString());
}
}
sb.Append(" where " + AllotBillId + "='" + AllotBillIdValue + "';");
sysStrSql.sqlString = sb.ToString();
sysStrSql.Param = dicParam;
listSql.Add(sysStrSql);//完成SQL语句的拼装
}
}
catch (Exception ex)
{
MessageBoxEx.Show(ex.Message, "异常提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
}
}
//清除
private void btnClear_Click(object sender, EventArgs e)
{
CommonCtrl.CmbBindDict(this.cmbJSFS, "sys_closing_way");
DataSources.BindComBoxDataEnum(cboStatus, typeof(DataSources.EnumStatus), true);//绑定状态
}
private void UCOrganizationView_Load(object sender, EventArgs e)
{
DataSources.BindComBoxDataEnum(cbostate, typeof(DataSources.EnumStatus), true);//绑定状态 启用 停用
BindTree();
string strSql = "SELECT o.*,(select USER_NAME from sys_user where user_id =o.create_by )as create_Username,";
strSql += "(select USER_NAME from sys_user where user_id =o.update_by ) as update_username ,";
strSql += "po.org_code as parentcode,po.org_name as parentname ,c.com_name ,c.com_code FROM tb_organization o ";
strSql += "left join tb_organization po on o.parent_id=po.org_id ";
strSql += "left join tb_company c on o.com_id=c.com_id ";
strSql += "where o.org_id='" + id + "'";
SQLObj sqlobj = new SQLObj();
sqlobj.cmdType = CommandType.Text;
sqlobj.Param = new Dictionary <string, ParamObj>();
sqlobj.sqlString = strSql;
DataSet ds = DBHelper.GetDataSet("查询组织", sqlobj);
if (ds == null || ds.Tables[0].Rows.Count <= 0)
{
MessageBoxEx.Show("查询组织失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
DataTable dt = ds.Tables[0];
CommonCtrl.SelectTreeView(tvCompany, dt.Rows[0]["parent_id"].ToString());
if (dt.Rows[0]["parentname"] != null && dt.Rows[0]["parentname"].ToString() != string.Empty)
{
lblporg_name.Text = dt.Rows[0]["parentname"].ToString();
}
else
{
lblporg_name.Text = CommonCtrl.IsNullToString(dt.Rows[0]["com_name"]);
}
if (dt.Rows[0]["parentcode"] != null && dt.Rows[0]["parentcode"].ToString() != string.Empty)
{
lblporg_code.Text = dt.Rows[0]["parentcode"].ToString();
}
else
{
lblporg_code.Text = CommonCtrl.IsNullToString(dt.Rows[0]["com_code"]);
}
lblorg_code.Text = dt.Rows[0]["org_code"].ToString();
lblorg_name.Text = dt.Rows[0]["org_name"].ToString();
lblorg_short_name.Text = dt.Rows[0]["org_short_name"].ToString();
lblremark.Text = dt.Rows[0]["remark"].ToString();
lblcontact_name.Text = dt.Rows[0]["contact_name"].ToString();
lblcontact_telephone.Text = dt.Rows[0]["contact_telephone"].ToString();
lblcreate_Username.Text = dt.Rows[0]["create_Username"].ToString();
lblcreate_time.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(dt.Rows[0]["create_time"].ToString())).ToString();
lblupdate_username.Text = dt.Rows[0]["update_username"].ToString();
lblupdate_time.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(dt.Rows[0]["update_time"].ToString())).ToString();
cbostate.SelectedValue = dt.Rows[0]["status"].ToString();
enumStatus = (int)dt.Rows[0]["status"];
SetSysManageViewBtn();
if (enumStatus == (int)DataSources.EnumStatus.Start)
{
btnStatus.Caption = "停用";
}
else
{
btnStatus.Caption = "启用";
}
}
public static IDataSource GetDataSource(DataSources dataSource)
{
return(AvailableDataSources[dataSource]);
}
private void InitializeComponent()
{
T_Detail = new T_DetailDataSource();
Dictionary.Variables.Add(new StiVariable("", "MyCompanyName", "MyCompanyName", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyTaxCode", "MyCompanyTaxCode", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyDirectorName", "MyCompanyDirectorName", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyCountryCode", "MyCompanyCountryCode", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyCountryName", "MyCompanyCountryName", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyCity", "MyCompanyCity", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyPostalCode", "MyCompanyPostalCode", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyAddress", "MyCompanyAddress", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyPhone", "MyCompanyPhone", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyFax", "MyCompanyFax", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyBankName", "MyCompanyBankName", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyBankCode", "MyCompanyBankCode", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyBankAccountNumber", "MyCompanyBankAccountNumber", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyVATPayerFlag", "MyCompanyVATPayerFlag", "", typeof(bool), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyConditionalUnitCurrencyCode", "MyCompanyConditionalUnitCurrencyCode", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyDefaultTradingCurrencyCode", "MyCompanyDefaultTradingCurrencyCode", "", typeof(string), "", false, false, false));
Dictionary.Variables.Add(new StiVariable("", "MyCompanyConditionalUnitCurrencyRate", "MyCompanyConditionalUnitCurrencyRate", "", typeof(decimal), "", false, false, false));
NeedsCompiling = false;
// Variables init
// Variables init
MyCompanyName = "";
MyCompanyTaxCode = "";
MyCompanyDirectorName = "";
MyCompanyCountryCode = "";
MyCompanyCountryName = "";
MyCompanyCity = "";
MyCompanyPostalCode = "";
MyCompanyAddress = "";
MyCompanyPhone = "";
MyCompanyFax = "";
MyCompanyBankName = "";
MyCompanyBankCode = "";
MyCompanyBankAccountNumber = "";
MyCompanyVATPayerFlag = false;
MyCompanyConditionalUnitCurrencyCode = "";
MyCompanyDefaultTradingCurrencyCode = "";
MyCompanyConditionalUnitCurrencyRate = 0m;
EngineVersion = StiEngineVersion.EngineV2;
ReferencedAssemblies = new[] {
"System.Dll",
"System.Drawing.Dll",
"System.Windows.Forms.Dll",
"System.Data.Dll",
"System.Xml.Dll",
"Stimulsoft.Controls.Dll",
"Stimulsoft.Base.Dll",
"Stimulsoft.Report.Dll"
};
ReportAlias = "Rpt Produc Location Price";
ReportAuthor = "Programmer.GE";
//
// ReportChanged
//
ReportChanged = new DateTime(2011, 6, 12, 21, 55, 48, 0);
//
// ReportCreated
//
ReportCreated = new DateTime(2009, 6, 28, 22, 3, 23, 0);
ReportDescription = "პრაისი";
ReportFile = "D:\\User\\Documents\\Projects\\Apothex\\Source\\Class Library\\Apothex.Reporting\\Product" +
"ion\\RptProducLocationPrice.mrt";
ReportGuid = "e242476ffaeb44b39344532841ed84f0";
ReportName = "RptProducLocationPrice";
ReportUnit = StiReportUnitType.Centimeters;
ReportVersion = "2010.3.900";
ScriptLanguage = StiReportLanguageType.CSharp;
//
// Page1
//
Page1 = new StiPage();
Page1.Columns = 2;
Page1.Guid = "0edad2017ef5402da56612e0faa7a32a";
Page1.Name = "Page1";
Page1.PageHeight = 29.7;
Page1.PageWidth = 21;
Page1.PaperSize = PaperKind.A4;
Page1.Border = new StiBorder(StiBorderSides.None, Color.Black, 2, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Page1.Brush = new StiSolidBrush(Color.Transparent);
//
// PageHeaderBand1
//
PageHeaderBand1 = new StiPageHeaderBand();
PageHeaderBand1.ClientRectangle = new RectangleD(0, 0.4, 20, 2.2);
PageHeaderBand1.Name = "PageHeaderBand1";
PageHeaderBand1.PrintOn = StiPrintOnType.OnlyFirstPage;
PageHeaderBand1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
PageHeaderBand1.Brush = new StiSolidBrush(Color.Transparent);
//
// Text4
//
Text4 = new StiText();
Text4.ClientRectangle = new RectangleD(2.4, 0, 7.6, 2);
Text4.Name = "Text4";
Text4.GetValue += new StiGetValueEventHandler(Text4__GetValue);
Text4.VertAlignment = StiVertAlignment.Center;
Text4.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text4.Brush = new StiSolidBrush(Color.Transparent);
Text4.Font = new Font("BPG Glaho Arial", 7F, FontStyle.Bold);
Text4.Guid = null;
Text4.Interaction = null;
Text4.Margins = new StiMargins(0, 0, 0, 0);
Text4.TextBrush = new StiSolidBrush(Color.Black);
Text4.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Image1
//
Image1 = new StiImage();
Image1.AspectRatio = true;
Image1.ClientRectangle = new RectangleD(0, 0, 2, 2);
Image1.Guid = "b4725dd4d92a41f5a0f373916b5b430e";
Image1.HorAlignment = StiHorAlignment.Center;
Image1.Name = "Image1";
Image1.Stretch = true;
Image1.VertAlignment = StiVertAlignment.Center;
Image1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Image1.Brush = new StiSolidBrush(Color.Transparent);
Image1.Image = null;
Image1.Interaction = null;
PageHeaderBand1.Guid = null;
PageHeaderBand1.Interaction = null;
//
// PageFooterBand1
//
PageFooterBand1 = new StiPageFooterBand();
PageFooterBand1.ClientRectangle = new RectangleD(0, 28.1, 20, 0.6);
PageFooterBand1.Name = "PageFooterBand1";
PageFooterBand1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
PageFooterBand1.Brush = new StiSolidBrush(Color.Transparent);
//
// Text3
//
Text3 = new StiText();
Text3.ClientRectangle = new RectangleD(0, 0, 19, 0.6);
Text3.HorAlignment = StiTextHorAlignment.Center;
Text3.Name = "Text3";
Text3.GetValue += new StiGetValueEventHandler(Text3__GetValue);
Text3.VertAlignment = StiVertAlignment.Center;
Text3.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text3.Brush = new StiSolidBrush(Color.Transparent);
Text3.Font = new Font("Arial", 8F);
Text3.Guid = null;
Text3.Interaction = null;
Text3.Margins = new StiMargins(0, 0, 0, 0);
Text3.TextBrush = new StiSolidBrush(Color.Black);
Text3.TextOptions = new StiTextOptions(false, false, false, 0F, HotkeyPrefix.None, StringTrimming.None);
PageFooterBand1.Guid = null;
PageFooterBand1.Interaction = null;
//
// HeaderVW_ProductLocation
//
HeaderVW_ProductLocation = new StiHeaderBand();
HeaderVW_ProductLocation.ClientRectangle = new RectangleD(0, 3.4, 10, 0.6);
HeaderVW_ProductLocation.Name = "HeaderVW_ProductLocation";
HeaderVW_ProductLocation.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderVW_ProductLocation.Brush = new StiSolidBrush(Color.Transparent);
//
// HeaderVW_ProductLocation_MedicamentName
//
HeaderVW_ProductLocation_MedicamentName = new StiText();
HeaderVW_ProductLocation_MedicamentName.ClientRectangle = new RectangleD(0, 0, 5.2, 0.6);
HeaderVW_ProductLocation_MedicamentName.HorAlignment = StiTextHorAlignment.Center;
HeaderVW_ProductLocation_MedicamentName.Name = "HeaderVW_ProductLocation_MedicamentName";
HeaderVW_ProductLocation_MedicamentName.GetValue += new StiGetValueEventHandler(HeaderVW_ProductLocation_MedicamentName__GetValue);
HeaderVW_ProductLocation_MedicamentName.VertAlignment = StiVertAlignment.Center;
HeaderVW_ProductLocation_MedicamentName.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderVW_ProductLocation_MedicamentName.Brush = new StiSolidBrush(Color.Gainsboro);
HeaderVW_ProductLocation_MedicamentName.Font = new Font("BPG Glaho Arial", 7F, FontStyle.Bold);
HeaderVW_ProductLocation_MedicamentName.Guid = null;
HeaderVW_ProductLocation_MedicamentName.Interaction = null;
HeaderVW_ProductLocation_MedicamentName.Margins = new StiMargins(0, 0, 0, 0);
HeaderVW_ProductLocation_MedicamentName.TextBrush = new StiSolidBrush(Color.Black);
HeaderVW_ProductLocation_MedicamentName.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// HeaderVW_ProductLocation_CountryName
//
HeaderVW_ProductLocation_CountryName = new StiText();
HeaderVW_ProductLocation_CountryName.ClientRectangle = new RectangleD(5.2, 0, 2.2, 0.6);
HeaderVW_ProductLocation_CountryName.HorAlignment = StiTextHorAlignment.Center;
HeaderVW_ProductLocation_CountryName.Name = "HeaderVW_ProductLocation_CountryName";
HeaderVW_ProductLocation_CountryName.GetValue += new StiGetValueEventHandler(HeaderVW_ProductLocation_CountryName__GetValue);
HeaderVW_ProductLocation_CountryName.VertAlignment = StiVertAlignment.Center;
HeaderVW_ProductLocation_CountryName.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderVW_ProductLocation_CountryName.Brush = new StiSolidBrush(Color.Gainsboro);
HeaderVW_ProductLocation_CountryName.Font = new Font("BPG Glaho Arial", 7F, FontStyle.Bold);
HeaderVW_ProductLocation_CountryName.Guid = null;
HeaderVW_ProductLocation_CountryName.Interaction = null;
HeaderVW_ProductLocation_CountryName.Margins = new StiMargins(0, 0, 0, 0);
HeaderVW_ProductLocation_CountryName.TextBrush = new StiSolidBrush(Color.Black);
HeaderVW_ProductLocation_CountryName.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// HeaderVW_ProductLocation_ListPrice
//
HeaderVW_ProductLocation_ListPrice = new StiText();
HeaderVW_ProductLocation_ListPrice.ClientRectangle = new RectangleD(9, 0, 1, 0.6);
HeaderVW_ProductLocation_ListPrice.HorAlignment = StiTextHorAlignment.Center;
HeaderVW_ProductLocation_ListPrice.Name = "HeaderVW_ProductLocation_ListPrice";
HeaderVW_ProductLocation_ListPrice.GetValue += new StiGetValueEventHandler(HeaderVW_ProductLocation_ListPrice__GetValue);
HeaderVW_ProductLocation_ListPrice.VertAlignment = StiVertAlignment.Center;
HeaderVW_ProductLocation_ListPrice.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
HeaderVW_ProductLocation_ListPrice.Brush = new StiSolidBrush(Color.Gainsboro);
HeaderVW_ProductLocation_ListPrice.Font = new Font("BPG Glaho Arial", 7F, FontStyle.Bold);
HeaderVW_ProductLocation_ListPrice.Guid = null;
HeaderVW_ProductLocation_ListPrice.Interaction = null;
HeaderVW_ProductLocation_ListPrice.Margins = new StiMargins(0, 0, 0, 0);
HeaderVW_ProductLocation_ListPrice.TextBrush = new StiSolidBrush(Color.Black);
HeaderVW_ProductLocation_ListPrice.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text2
//
Text2 = new StiText();
Text2.ClientRectangle = new RectangleD(7.4, 0, 1.6, 0.6);
Text2.Guid = "b2ee6a7204874db4bc1e2bae90edc3a9";
Text2.HorAlignment = StiTextHorAlignment.Center;
Text2.Name = "Text2";
Text2.GetValue += new StiGetValueEventHandler(Text2__GetValue);
Text2.Type = StiSystemTextType.Expression;
Text2.VertAlignment = StiVertAlignment.Center;
Text2.Border = new StiBorder(StiBorderSides.All, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text2.Brush = new StiSolidBrush(Color.Gainsboro);
Text2.Font = new Font("BPG Glaho Arial", 7F, FontStyle.Bold);
Text2.Interaction = null;
Text2.Margins = new StiMargins(0, 0, 0, 0);
Text2.TextBrush = new StiSolidBrush(Color.Black);
Text2.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
HeaderVW_ProductLocation.Guid = null;
HeaderVW_ProductLocation.Interaction = null;
//
// DataVW_ProductLocation
//
DataVW_ProductLocation = new StiDataBand();
DataVW_ProductLocation.ClientRectangle = new RectangleD(0, 4.8, 10, 0.6);
DataVW_ProductLocation.DataSourceName = "T_Detail";
DataVW_ProductLocation.Name = "DataVW_ProductLocation";
DataVW_ProductLocation.Sort = new[] {
"ASC",
"ProductName"
};
DataVW_ProductLocation.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataVW_ProductLocation.Brush = new StiSolidBrush(Color.Transparent);
DataVW_ProductLocation.BusinessObjectGuid = null;
//
// DataVW_ProductLocation_MedicamentName
//
DataVW_ProductLocation_MedicamentName = new StiText();
DataVW_ProductLocation_MedicamentName.CanGrow = true;
DataVW_ProductLocation_MedicamentName.ClientRectangle = new RectangleD(0, 0, 5.2, 0.6);
DataVW_ProductLocation_MedicamentName.Name = "DataVW_ProductLocation_MedicamentName";
DataVW_ProductLocation_MedicamentName.GetValue += new StiGetValueEventHandler(DataVW_ProductLocation_MedicamentName__GetValue);
DataVW_ProductLocation_MedicamentName.VertAlignment = StiVertAlignment.Center;
DataVW_ProductLocation_MedicamentName.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataVW_ProductLocation_MedicamentName.Brush = new StiSolidBrush(Color.Transparent);
DataVW_ProductLocation_MedicamentName.Font = new Font("BPG Glaho Arial", 6F);
DataVW_ProductLocation_MedicamentName.Guid = null;
DataVW_ProductLocation_MedicamentName.Interaction = null;
DataVW_ProductLocation_MedicamentName.Margins = new StiMargins(0, 0, 0, 0);
DataVW_ProductLocation_MedicamentName.TextBrush = new StiSolidBrush(Color.Black);
DataVW_ProductLocation_MedicamentName.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// DataVW_ProductLocation_CountryName
//
DataVW_ProductLocation_CountryName = new StiText();
DataVW_ProductLocation_CountryName.CanGrow = true;
DataVW_ProductLocation_CountryName.ClientRectangle = new RectangleD(5.2, 0, 2.2, 0.6);
DataVW_ProductLocation_CountryName.HorAlignment = StiTextHorAlignment.Right;
DataVW_ProductLocation_CountryName.Name = "DataVW_ProductLocation_CountryName";
DataVW_ProductLocation_CountryName.GetValue += new StiGetValueEventHandler(DataVW_ProductLocation_CountryName__GetValue);
DataVW_ProductLocation_CountryName.VertAlignment = StiVertAlignment.Center;
DataVW_ProductLocation_CountryName.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataVW_ProductLocation_CountryName.Brush = new StiSolidBrush(Color.Transparent);
DataVW_ProductLocation_CountryName.Font = new Font("BPG Glaho Arial", 6F);
DataVW_ProductLocation_CountryName.Guid = null;
DataVW_ProductLocation_CountryName.Interaction = null;
DataVW_ProductLocation_CountryName.Margins = new StiMargins(0, 0, 0, 0);
DataVW_ProductLocation_CountryName.TextBrush = new StiSolidBrush(Color.Black);
DataVW_ProductLocation_CountryName.TextFormat = new StiPercentageFormatService(0, 0, ",", 4, " ", 3, "%", true, false, " ");
DataVW_ProductLocation_CountryName.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// DataVW_ProductLocation_ListPrice
//
DataVW_ProductLocation_ListPrice = new StiText();
DataVW_ProductLocation_ListPrice.CanGrow = true;
DataVW_ProductLocation_ListPrice.ClientRectangle = new RectangleD(9, 0, 1, 0.6);
DataVW_ProductLocation_ListPrice.HorAlignment = StiTextHorAlignment.Right;
DataVW_ProductLocation_ListPrice.Name = "DataVW_ProductLocation_ListPrice";
DataVW_ProductLocation_ListPrice.GetValue += new StiGetValueEventHandler(DataVW_ProductLocation_ListPrice__GetValue);
DataVW_ProductLocation_ListPrice.VertAlignment = StiVertAlignment.Center;
DataVW_ProductLocation_ListPrice.Border = new StiBorder(StiBorderSides.Right, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
DataVW_ProductLocation_ListPrice.Brush = new StiSolidBrush(Color.Transparent);
DataVW_ProductLocation_ListPrice.Font = new Font("BPG Glaho Arial", 6F);
DataVW_ProductLocation_ListPrice.Guid = null;
DataVW_ProductLocation_ListPrice.Interaction = null;
DataVW_ProductLocation_ListPrice.Margins = new StiMargins(0, 0, 0, 0);
DataVW_ProductLocation_ListPrice.TextBrush = new StiSolidBrush(Color.Black);
DataVW_ProductLocation_ListPrice.TextFormat = new StiNumberFormatService(1, ",", 2, " ", 3, true, false, " ");
DataVW_ProductLocation_ListPrice.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
//
// Text1
//
Text1 = new StiText();
Text1.CanGrow = true;
Text1.ClientRectangle = new RectangleD(7.4, 0, 1.6, 0.6);
Text1.Guid = "5cfcbb441d534f4ba95c949ddd2c6da5";
Text1.HorAlignment = StiTextHorAlignment.Right;
Text1.Name = "Text1";
Text1.GetValue += new StiGetValueEventHandler(Text1__GetValue);
Text1.Type = StiSystemTextType.DataColumn;
Text1.VertAlignment = StiVertAlignment.Center;
Text1.Border = new StiBorder(StiBorderSides.None, Color.Black, 1, StiPenStyle.Solid, false, 4, new StiSolidBrush(Color.Black));
Text1.Brush = new StiSolidBrush(Color.Transparent);
Text1.Font = new Font("BPG Glaho Arial", 6F);
Text1.Interaction = null;
Text1.Margins = new StiMargins(0, 0, 0, 0);
Text1.TextBrush = new StiSolidBrush(Color.Black);
Text1.TextFormat = new StiPercentageFormatService(0, 0, ",", 2, " ", 3, "%", true, true, " ");
Text1.TextOptions = new StiTextOptions(false, false, true, 0F, HotkeyPrefix.None, StringTrimming.None);
DataVW_ProductLocation.DataRelationName = null;
DataVW_ProductLocation.Guid = null;
DataVW_ProductLocation.Interaction = null;
DataVW_ProductLocation.MasterComponent = null;
Page1.ExcelSheetValue = null;
Page1.Interaction = null;
Page1.Margins = new StiMargins(0.5, 0.5, 0.5, 0.5);
Page1_Watermark = new StiWatermark();
Page1_Watermark.Font = new Font("Arial", 100F);
Page1_Watermark.Image = null;
Page1_Watermark.TextBrush = new StiSolidBrush(Color.FromArgb(50, 0, 0, 0));
Page1.Rendering += new EventHandler(Page1_Rendering);
RptProducLocationPrice_PrinterSettings = new StiPrinterSettings();
PrinterSettings = RptProducLocationPrice_PrinterSettings;
Page1.Report = this;
Page1.Watermark = Page1_Watermark;
PageHeaderBand1.Page = Page1;
PageHeaderBand1.Parent = Page1;
Text4.Page = Page1;
Text4.Parent = PageHeaderBand1;
Image1.Page = Page1;
Image1.Parent = PageHeaderBand1;
PageFooterBand1.Page = Page1;
PageFooterBand1.Parent = Page1;
Text3.Page = Page1;
Text3.Parent = PageFooterBand1;
HeaderVW_ProductLocation.Page = Page1;
HeaderVW_ProductLocation.Parent = Page1;
HeaderVW_ProductLocation_MedicamentName.Page = Page1;
HeaderVW_ProductLocation_MedicamentName.Parent = HeaderVW_ProductLocation;
HeaderVW_ProductLocation_CountryName.Page = Page1;
HeaderVW_ProductLocation_CountryName.Parent = HeaderVW_ProductLocation;
HeaderVW_ProductLocation_ListPrice.Page = Page1;
HeaderVW_ProductLocation_ListPrice.Parent = HeaderVW_ProductLocation;
Text2.Page = Page1;
Text2.Parent = HeaderVW_ProductLocation;
DataVW_ProductLocation.Page = Page1;
DataVW_ProductLocation.Parent = Page1;
DataVW_ProductLocation_MedicamentName.Page = Page1;
DataVW_ProductLocation_MedicamentName.Parent = DataVW_ProductLocation;
DataVW_ProductLocation_CountryName.Page = Page1;
DataVW_ProductLocation_CountryName.Parent = DataVW_ProductLocation;
DataVW_ProductLocation_ListPrice.Page = Page1;
DataVW_ProductLocation_ListPrice.Parent = DataVW_ProductLocation;
Text1.Page = Page1;
Text1.Parent = DataVW_ProductLocation;
EndRender += new EventHandler(RptProducLocationPriceWordsToEnd__EndRender);
//
// Add to PageHeaderBand1.Components
//
PageHeaderBand1.Components.Clear();
PageHeaderBand1.Components.AddRange(new StiComponent[] {
Text4,
Image1
});
//
// Add to PageFooterBand1.Components
//
PageFooterBand1.Components.Clear();
PageFooterBand1.Components.AddRange(new StiComponent[] {
Text3
});
//
// Add to HeaderVW_ProductLocation.Components
//
HeaderVW_ProductLocation.Components.Clear();
HeaderVW_ProductLocation.Components.AddRange(new StiComponent[] {
HeaderVW_ProductLocation_MedicamentName,
HeaderVW_ProductLocation_CountryName,
HeaderVW_ProductLocation_ListPrice,
Text2
});
//
// Add to DataVW_ProductLocation.Components
//
DataVW_ProductLocation.Components.Clear();
DataVW_ProductLocation.Components.AddRange(new StiComponent[] {
DataVW_ProductLocation_MedicamentName,
DataVW_ProductLocation_CountryName,
DataVW_ProductLocation_ListPrice,
Text1
});
//
// Add to Page1.Components
//
Page1.Components.Clear();
Page1.Components.AddRange(new StiComponent[] {
PageHeaderBand1,
PageFooterBand1,
HeaderVW_ProductLocation,
DataVW_ProductLocation
});
//
// Add to Pages
//
Pages.Clear();
Pages.AddRange(new[] {
Page1
});
T_Detail.Columns.AddRange(new[] {
new StiDataColumn("ProductID", "ProductID", "ProductID", typeof(int)),
new StiDataColumn("ProductName", "ProductName", "ProductName", typeof(string)),
new StiDataColumn("CountryName", "CountryName", "CountryName", typeof(string)),
new StiDataColumn("Serie", "Serie", "Serie", typeof(string)),
new StiDataColumn("UnitPrice", "UnitPrice", "UnitPrice", typeof(decimal)),
new StiDataColumn("Discount", "Discount", "Discount", typeof(decimal))
});
DataSources.Add(T_Detail);
}
private XSSFWorkbook CreateBarchart()
{
XSSFWorkbook workbook = new XSSFWorkbook();
XSSFSheet sheet = (XSSFSheet)workbook.CreateSheet("WorkForceAnalytics");
XSSFCellStyle styleHeader = (XSSFCellStyle)workbook.CreateCellStyle();
styleHeader.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Center;
//styleHeader.SetFont(getNewXSSFFont(workbook, styleHeader));
XSSFCellStyle style = (XSSFCellStyle)workbook.CreateCellStyle();
style.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Left;
XSSFRow row1 = (XSSFRow)sheet.CreateRow(0);
row1.CreateCell(0).SetCellValue("");
List <string> lstdatase = new List <string>(4)
{
"A1",
"B1",
"C1",
"D1",
"E1"
};
for (int i = 1; i < 5; i++)
{
row1.CreateCell(i).SetCellValue(lstdatase[i - 1].ToString());
row1.GetCell(i).CellStyle = styleHeader;
}
int rowvalue = 1;
List <string> lstdata = new List <string>(8)
{
"A",
"B",
"C",
"D",
"E",
"F",
"G",
"H"
};
int d = 10;
XSSFDrawing drawing = (XSSFDrawing)sheet.CreateDrawingPatriarch();
XSSFClientAnchor anchor = (XSSFClientAnchor)drawing.CreateAnchor(0, 0, 0, 0, 6, 1, 15, 18);
IChart chart = drawing.CreateChart(anchor);
IChartLegend legend = chart.GetOrCreateLegend();
legend.Position = (LegendPosition.Bottom);
IBarChartData <string, double> data = chart.ChartDataFactory.CreateBarChartData <string, double>();
IChartAxis bottomAxis = chart.ChartAxisFactory.CreateCategoryAxis(AxisPosition.Bottom);
IValueAxis leftAxis = chart.ChartAxisFactory.CreateValueAxis(AxisPosition.Left);
leftAxis.Crosses = AxisCrosses.AutoZero;
leftAxis.SetCrossBetween(AxisCrossBetween.Between);
IChartDataSource <string> xs = DataSources.FromStringCellRange(sheet, new NPOI.SS.Util.CellRangeAddress(0, 0, 1, 5 - 1));
for (int ii = 0; ii < 8; ii++)
{
XSSFRow rownew = (XSSFRow)sheet.CreateRow(rowvalue);
rownew.CreateCell(0).SetCellValue(lstdata[ii].ToString());
for (int i = 1; i < 5; i++)
{
rownew.CreateCell(i).SetCellValue(d * 0.1);
d++;
rownew.GetCell(i).CellStyle = style;
}
rowvalue++;
IChartDataSource <double> ys = DataSources.FromNumericCellRange(sheet, new NPOI.SS.Util.CellRangeAddress(ii + 1, ii + 1, 1, 5 - 1));
data.AddSeries(xs, ys).SetTitle(lstdata[ii].ToString());
}
chart.Plot(data, bottomAxis, leftAxis);
sheet.ForceFormulaRecalculation = true;
return(workbook);
}
private void InitData()
{
CommonCtrl.CmbBindDict(this.cboannouncement_type, "announcement_type");//公告分类
DataSources.BindComBoxDataEnum(this.cmbStatus, typeof(DataSources.EnumStatus), true);
CommonCtrl.CmbBindDeptment(this.cmbOrg, string.Empty);
}
public void UnityResolverTests()
{
var container = new UnityContainer();
var dsSqlServer1 = new DataSource("ICESQLDB1", ProviderTypes.SqlServer, "Data Source=icermauatsql;Initial Catalog=ICE2DB;User ID=ICEUAT;Password=ic3uat!@");
var dsSqlServer2 = new DataSource("ICESQLDB2", ProviderTypes.SqlServer, "Data Source=icermauatsql;Initial Catalog=ICE2DB;User ID=ICEUAT;Password=ic3uat!@");
//var dsAs400 = new DataSource("ICEDB", ProviderTypes.DB2iSeries, "DataCompression=True; DataSource=ATHINA; Password=XK40XK40; UserID=XK40;");
var dataSources = new DataSources()
{
dsSqlServer1, dsSqlServer2
};
var mapperConfig = new AutoMapper.MapperConfiguration(cfg =>
{
cfg.CreateMap <MockEntityModel, MockEntity>();
});
var mapper = mapperConfig.CreateMapper();
var unityBoostraper = new UnityDaliaResolverBoostraper(container, dataSources, new Mapping.AutoMapper.Mapper(mapper));
unityBoostraper.Extend(new UnityLinqToDBResolverRegistrator());
var dalResolver = container.Resolve <IDaliaResolver>();
var childContainer1 = container.CreateChildContainer();
var dalResolver1 = childContainer1.Resolve <IDaliaResolver>();
var childContainer2 = container.CreateChildContainer();
var dalResolver2 = childContainer2.Resolve <IDaliaResolver>();
var context = dalResolver.ResolveSingleContext <MockContext>();
var context1 = dalResolver1.ResolveSingleContext <MockContext>();
var context1_1 = dalResolver1.ResolveSingleContext <MockContext>();
var context1_2 = dalResolver1.ResolveNewContext <MockContext>();
var context2 = dalResolver2.ResolveSingleContext <MockContext>();
var dataRepository = dalResolver.ResolveRepository <MockRepository>();
var dataRepository1 = dalResolver1.ResolveRepository <MockRepository>();
var dataRepository1_1 = dalResolver1.ResolveRepository <MockRepository>();
var dataRepository2 = dalResolver2.ResolveRepository <MockRepository>();
var dataQueryprovider = dalResolver.ResolveQueryProvider <MockQueryProvider>();
var dataQueryprovider1 = dalResolver1.ResolveQueryProvider <MockQueryProvider>();
var dataQueryprovider1_1 = dalResolver1.ResolveQueryProvider <MockQueryProvider>();
var dataQueryprovider2 = dalResolver2.ResolveQueryProvider <MockQueryProvider>();
Assert.AreNotSame(context, context1);
Assert.AreNotSame(context1, context2);
Assert.AreSame(context1, context1_1);
Assert.AreNotSame(context1, context1_2);
Assert.AreNotSame(dataRepository1.Context, dataRepository.Context);
Assert.AreSame(dataRepository1.Context, dataRepository1_1.Context);
Assert.AreNotSame(dataRepository2.Context, dataRepository.Context);
Assert.AreNotSame(dataRepository2.Context, dataRepository1.Context);
Assert.AreNotSame(dataQueryprovider1.Context, dataQueryprovider.Context);
Assert.AreSame(dataQueryprovider1.Context, dataQueryprovider1_1.Context);
Assert.AreNotSame(dataQueryprovider2.Context, dataQueryprovider.Context);
Assert.AreNotSame(dataQueryprovider2.Context, dataQueryprovider1.Context);
}
/// <summary> 加载采购计划信息和配件信息
/// </summary>
/// <param name="order_id"></param>
private void LoadInfo(string order_id)
{
if (!string.IsNullOrEmpty(order_id))
{
//1.查看一条采购订单信息
DataTable dt = DBHelper.GetTable("查看一条采购订单信息", "tb_parts_purchase_order", "*", " order_id='" + order_id + "'", "", "");
if (dt != null && dt.Rows.Count > 0)
{
CommonFuncCall.SetModlByDataTable(tb_partspurchaseorder_Model, dt);
CommonFuncCall.SetShowControlValue(this, tb_partspurchaseorder_Model, "");
chkis_suspend.Checked = tb_partspurchaseorder_Model.is_suspend == "0";//选中(中止)：0,未选中(不中止)：1
if (!string.IsNullOrEmpty(lblorder_status.Text))
{
DataSources.EnumAuditStatus enumDataSources = (DataSources.EnumAuditStatus)Convert.ToInt16(lblorder_status.Text);
lblorder_status.Text = DataSources.GetDescription(enumDataSources, true);
}
if (!string.IsNullOrEmpty(lblorder_date.Text))
{
long ticks = Convert.ToInt64(lblorder_date.Text);
lblorder_date.Text = Common.UtcLongToLocalDateTime(ticks).ToString();
}
if (!string.IsNullOrEmpty(lblvalid_till.Text))
{
long ticks = Convert.ToInt64(lblvalid_till.Text);
lblvalid_till.Text = Common.UtcLongToLocalDateTime(ticks).ToString();
}
if (!string.IsNullOrEmpty(lblarrival_date.Text))
{
long ticks = Convert.ToInt64(lblarrival_date.Text);
lblarrival_date.Text = Common.UtcLongToLocalDateTime(ticks).ToString();
}
lblcreate_time.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(tb_partspurchaseorder_Model.create_time.ToString())).ToString();
if (tb_partspurchaseorder_Model.update_time > 0)
{
lblupdate_time.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(tb_partspurchaseorder_Model.update_time.ToString())).ToString();
}
orderstatus = tb_partspurchaseorder_Model.order_status.ToString();
if (orderstatus == Convert.ToInt32(DataSources.EnumAuditStatus.SUBMIT).ToString())
{
//已提交状态屏蔽提交、编辑、删除按钮
base.btnSubmit.Enabled = false;
base.btnEdit.Enabled = false;
base.btnDelete.Enabled = false;
base.btnActivation.Enabled = false;
}
else if (orderstatus == Convert.ToInt32(DataSources.EnumAuditStatus.AUDIT).ToString())
{
//已审核时屏蔽提交、审核、编辑、删除按钮
base.btnSubmit.Enabled = false;
base.btnVerify.Enabled = false;
base.btnEdit.Enabled = false;
base.btnDelete.Enabled = false;
base.btnActivation.Enabled = false;
}
else if (orderstatus == Convert.ToInt32(DataSources.EnumAuditStatus.NOTAUDIT).ToString() || orderstatus == Convert.ToInt32(DataSources.EnumAuditStatus.DRAFT).ToString())
{
//审核没通过时屏蔽审核按钮
base.btnVerify.Enabled = false;
}
else if (orderstatus == Convert.ToInt32(DataSources.EnumAuditStatus.Invalid).ToString())
{
base.btnActivation.Caption = "激活";
base.btnSubmit.Enabled = false;
base.btnVerify.Enabled = false;
base.btnEdit.Enabled = false;
}
}
}
}
/// <summary> 激活/作废
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void UCPurchasePlanOrderView_InvalidOrActivationEvent(object sender, EventArgs e)
{
string strmsg = string.Empty;
List <SysSQLString> listSql = new List <SysSQLString>();
SysSQLString sysStringSql = new SysSQLString();
sysStringSql.cmdType = CommandType.Text;
Dictionary <string, string> dic = new Dictionary <string, string>(); //参数
dic.Add("sale_order_id", SaleorderId); //单据ID
dic.Add("update_by", GlobalStaticObj.UserID); //修改人Id
dic.Add("update_name", GlobalStaticObj.UserName); //修改人姓名
dic.Add("update_time", Common.LocalDateTimeToUtcLong(DateTime.Now).ToString()); //修改时间
if (orderstatus != Convert.ToInt32(DataSources.EnumAuditStatus.Invalid).ToString())
{
strmsg = "作废";
dic.Add("order_status", Convert.ToInt32(DataSources.EnumAuditStatus.Invalid).ToString()); //单据状态编号
dic.Add("order_status_name", DataSources.GetDescription(DataSources.EnumAuditStatus.Invalid, true)); //单据状态名称
}
else
{
strmsg = "激活";
string order_status = string.Empty;
string order_status_name = string.Empty;
DataTable dvt = DBHelper.GetTable("获得销售订单的前一个状态", "tb_parts_sale_order_BackUp", "order_status,order_status_name", "sale_order_id='" + SaleorderId + "'", "", "order by update_time desc");
if (dvt != null && dvt.Rows.Count > 0)
{
DataRow dr = dvt.Rows[0];
order_status = CommonCtrl.IsNullToString(dr["order_status"]);
if (order_status == Convert.ToInt32(DataSources.EnumAuditStatus.Invalid).ToString())
{
DataRow dr1 = dvt.Rows[1];
order_status = CommonCtrl.IsNullToString(dr1["order_status"]);
order_status_name = CommonCtrl.IsNullToString(dr1["order_status_name"]);
}
}
order_status = !string.IsNullOrEmpty(order_status) ? order_status : Convert.ToInt32(DataSources.EnumAuditStatus.DRAFT).ToString();
if (order_status == Convert.ToInt32(DataSources.EnumAuditStatus.NOTAUDIT).ToString())
{
order_status_name = DataSources.GetDescription(DataSources.EnumAuditStatus.NOTAUDIT, true);
}
else if (order_status == Convert.ToInt32(DataSources.EnumAuditStatus.DRAFT).ToString())
{
order_status_name = DataSources.GetDescription(DataSources.EnumAuditStatus.DRAFT, true);
}
dic.Add("order_status", order_status); //单据状态
dic.Add("order_status_name", order_status_name); //单据状态名称
}
sysStringSql.sqlString = "update tb_parts_sale_order set order_status=@order_status,order_status_name=@order_status_name,update_by=@update_by,update_name=@update_name,update_time=@update_time where sale_order_id=@sale_order_id";
sysStringSql.Param = dic;
listSql.Add(sysStringSql);
if (MessageBoxEx.Show("确认要" + strmsg + "吗?", "提示", MessageBoxButtons.OKCancel) != DialogResult.OK)
{
return;
}
if (DBHelper.BatchExeSQLStringMultiByTrans("更新单据状态为" + strmsg + "", listSql))
{
MessageBoxEx.Show("" + strmsg + "成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
uc.BindgvSaleOrderList();
deleteMenuByTag(this.Tag.ToString(), uc.Name);
}
else
{
MessageBoxEx.Show("" + strmsg + "失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// 数据保存/提交 方法
/// </summary>
/// <param name="HandleTypeName">保存/提交</param>
private void SaveOrSubmitMethod(string HandleTypeName)
{
try
{
if (CheckListInfo())
{
gvPartsMsgList.EndEdit();
string opName = "其它收货单操作";
lblorder_num.Text = CommonUtility.GetNewNo(DataSources.EnumProjectType.ReceiptBill);//获取其它收货单编号
if (HandleTypeName == submit)
{
txtorder_status_name.Caption = DataSources.GetDescription(DataSources.EnumAuditStatus.SUBMIT, true);
}
else if (HandleTypeName == save)
{
txtorder_status_name.Caption = DataSources.GetDescription(DataSources.EnumAuditStatus.DRAFT, true);
}
List <SysSQLString> listSql = new List <SysSQLString>();
if (status == WindowStatus.Add || status == WindowStatus.Copy)
{
StockReceiptId = Guid.NewGuid().ToString();
AddReceiptBillSql(listSql, ReceiptBillEntity, StockReceiptId, HandleTypeName);
opName = "新增其它收货单";
AddOrEditPartsListMsg(listSql, StockReceiptId, WindowStatus.Add);
}
else if (status == WindowStatus.Edit)
{
EditReceiptBillSql(listSql, ReceiptBillEntity, StockReceiptId, HandleTypeName);
opName = "修改其它收货单";
AddOrEditPartsListMsg(listSql, StockReceiptId, WindowStatus.Edit);
}
if (DBHelper.BatchExeSQLStringMultiByTrans(opName, listSql))
{
if (HandleTypeName == submit)
{
MessageBoxEx.Show("提交成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (HandleTypeName == save)
{
MessageBoxEx.Show("保存成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
long StartDate = Common.LocalDateTimeToUtcLong(Convert.ToDateTime(DateTime.Now.AddMonths(-6).ToShortDateString())); //获取当前日期的半年前的日期
long EndDate = Common.LocalDateTimeToUtcLong(Convert.ToDateTime(DateTime.Now.ToShortDateString())); //获取当前日期
string DefaultWhere = " enable_flag=1 and RptBillTb.order_date between " + StartDate + " and " + EndDate; //默认查询条件
UCReceiptBM.GetReceiptBillList(DefaultWhere); //更新单据列表
deleteMenuByTag(this.Tag.ToString(), UCReceiptBM.Name);
}
else
{
if (HandleTypeName == submit)
{
MessageBoxEx.Show("提交失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (HandleTypeName == save)
{
MessageBoxEx.Show("保存失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
return;
}
}
}
catch (Exception ex)
{
MessageBoxEx.Show(ex.Message, "异常提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
}
}
private void GetRepairInfo()
{
DataTable dt = DBHelper.GetTable("维修单详情", "tb_maintain_info a left join tb_maintain_settlement_info b on a.maintain_id=b.maintain_id ", "*", string.Format(" a.maintain_id='{0}'", strRepairId), "", "");
if (dt.Rows.Count > 0)
{
#region 基本信息
DataRow dr = dt.Rows[0];
labMaintain_noS.Text = CommonCtrl.IsNullToString(dr["maintain_no"]); //维修单号
string strReTime = CommonCtrl.IsNullToString(dr["reception_time"]); //接待时间
if (!string.IsNullOrEmpty(strReTime))
{
labRTimeS.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(strReTime)).ToString("yyyy-MM-dd HH:mm");
}
else
{
labRTimeS.Text = string.Empty;
}
labCustomNOS.Text = CommonCtrl.IsNullToString(dr["customer_code"]); //客户编码
labCustomNameS.Text = CommonCtrl.IsNullToString(dr["customer_name"]); //客户名称
labContactS.Text = CommonCtrl.IsNullToString(dr["linkman"]); //联系人
labContactPhoneS.Text = CommonCtrl.IsNullToString(dr["link_man_mobile"]); //联系人电话
labCarNOS.Text = CommonCtrl.IsNullToString(dr["vehicle_no"]); //车牌号
labCarTypeS.Text = GetDicName(CommonCtrl.IsNullToString(dr["vehicle_model"])); //车型
labCarBrandS.Text = GetDicName(CommonCtrl.IsNullToString(dr["vehicle_brand"])); //车辆品牌
labVINS.Text = CommonCtrl.IsNullToString(dr["vehicle_vin"]); //VIN
labEngineNoS.Text = CommonCtrl.IsNullToString(dr["engine_no"]); //发动机号
labColorS.Text = GetDicName(CommonCtrl.IsNullToString(dr["vehicle_color"])); //颜色
labDriverS.Text = CommonCtrl.IsNullToString(dr["driver_name"]); //司机
labDriverPhoneS.Text = CommonCtrl.IsNullToString(dr["driver_mobile"]); //司机手机
labRepTypeS.Text = GetDicName(CommonCtrl.IsNullToString(dr["maintain_type"])); //维修类别
labPayTypeS.Text = GetDicName(CommonCtrl.IsNullToString(dr["maintain_payment"])); //维修付费方式
labMlS.Text = CommonCtrl.IsNullToString(dr["oil_into_factory"]); //进场油量
labMilS.Text = CommonCtrl.IsNullToString(dr["travel_mileage"]); //行驶里程
labDescS.Text = CommonCtrl.IsNullToString(dr["fault_describe"]); //故障描述
labRemarkS.Text = CommonCtrl.IsNullToString(dr["remark"]); //备注
if (CommonCtrl.IsNullToString(dr["orders_source"]) == "3")
{
labStatusS.Text = "维修单结算" + DataSources.GetDescription(typeof(DataSources.EnumAuditStatus), int.Parse(CommonCtrl.IsNullToString(dr["info_status"])));;
}
else
{
if (CommonCtrl.IsNullToString(dr["info_status"]) != Convert.ToInt32(DataSources.EnumAuditStatus.AUDIT).ToString())
{
labStatusS.Text = "接待" + DataSources.GetDescription(typeof(DataSources.EnumAuditStatus), int.Parse(CommonCtrl.IsNullToString(dr["info_status"])));
}
else
{
labStatusS.Text = DataSources.GetDescription(typeof(DataSources.EnumDispatchStatus), int.Parse(CommonCtrl.IsNullToString(dr["dispatch_status"])));//单据状态
}
}
labDepartS.Text = GetDepartmentName(CommonCtrl.IsNullToString(dr["org_id"])); //部门
labAttnS.Text = GetUserSetName(CommonCtrl.IsNullToString(dr["responsible_opid"])); //经办人
labCreatePersonS.Text = CommonCtrl.IsNullToString(dr["create_name"]); //创建人
string strCreateTime = CommonCtrl.IsNullToString(dr["create_time"]); //创建时间
if (!string.IsNullOrEmpty(strCreateTime))
{
labCreateTimeS.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(strCreateTime)).ToString("yyyy-MM-dd HH:mm");
}
else
{
labCreateTimeS.Text = string.Empty;
}
labFinallyPerS.Text = CommonCtrl.IsNullToString(dr["update_name"]); //最后编辑人
string strFinallyTime = CommonCtrl.IsNullToString(dr["update_time"]); //最后编辑时间
if (!string.IsNullOrEmpty(strFinallyTime))
{
labFinallyTimeS.Text = Common.UtcLongToLocalDateTime(Convert.ToInt64(strFinallyTime)).ToString("yyyy-MM-dd HH:mm");
}
else
{
labFinallyTimeS.Text = string.Empty;
}
labmaintain_manS.Text = CommonCtrl.IsNullToString(dr["maintain_man"]);//服务顾问
#region 会员信息
string strMemnerID = CommonCtrl.IsNullToString(dr["member_id"]);//会员信息Id
if (!string.IsNullOrEmpty(strMemnerID))
{
DataTable dct = DBHelper.GetTable("获取会员信息", "tb_customer", "member_number,member_class,accessories_discount,workhours_discount", " is_member='1' and cust_id='" + strMemnerID + "'", "", "");
labMemberNoS.Text = CommonCtrl.IsNullToString(dr["member_number"]); //会员卡号
labMemberGradeS.Text = CommonCtrl.IsNullToString(dr["member_class"]); //会员等级
labMemberPZkS.Text = CommonCtrl.IsNullToString(dr["workhours_discount"]); //会员项目折扣
labMemberLZkS.Text = CommonCtrl.IsNullToString(dr["accessories_discount"]); //会员用料折扣
}
else
{
labMemberNoS.Text = string.Empty; //会员卡号
labMemberGradeS.Text = string.Empty; //会员等级
labMemberPZkS.Text = string.Empty; //会员项目折扣
labMemberLZkS.Text = string.Empty;
}
#endregion
labGshkS.Text = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dr["man_hour_sum_money"]), 2); //工时货款
labGsslS.Text = CommonCtrl.IsNullToString(dr["man_hour_tax_rate"]); //工时税率
labGsseS.Text = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dr["man_hour_tax_rate"]), 2); //工时税额
labGssjhjS.Text = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dr["man_hour_sum"]), 2); //工时税价合计
labPjhkS.Text = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dr["fitting_sum_money"]), 2); //配件货款
labPjslS.Text = CommonCtrl.IsNullToString(dr["fitting_tax_rate"]); //配件税率
labPjseS.Text = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dr["fitting_tax_cost"]), 2); //配件税额
labPjsjhjS.Text = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dr["fitting_sum"]), 2); //配件税价合计
labQtflS.Text = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dr["other_item_sum_money"]), 2); //其他项目费用
QtslS.Text = CommonCtrl.IsNullToString(dr["other_item_tax_rate"]); //其他项目税率
labQtseS.Text = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dr["other_item_tax_cost"]), 2); //其他项目税额
labQthjS.Text = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dr["other_item_sum"]), 2); //其他项目价税合计
labYH.Text = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dr["privilege_cost"]), 2); //优惠费用
labShould.Text = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dr["should_sum"]), 2); //应收总额
labReceive.Text = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dr["received_sum"]), 2); //实收总额
labDebt.Text = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dr["debt_cost"]), 2); //欠款金额
labInvoiceType.Text = CommonCtrl.IsNullToString(dr["make_invoice_type"]); //开票类型
labPayment.Text = CommonCtrl.IsNullToString(dr["payment_terms"]); //结算方式
labSetAccount.Text = CommonCtrl.IsNullToString(dr["settlement_account"]); //结算账户
labSetCompany.Text = CommonCtrl.IsNullToString(dr["settle_company"]); //结算单位
#endregion
#region 底部datagridview数据
#region 维修项目数据
//维修项目数据
decimal dcPmoney = 0;
DataTable dpt = DBHelper.GetTable("维修项目数据", "tb_maintain_item", "*", string.Format(" maintain_id='{0}'", strRepairId), "", "");;
if (dpt.Rows.Count > 0)
{
if (dpt.Rows.Count > dgvproject.Rows.Count)
{
dgvproject.Rows.Add(dpt.Rows.Count - dgvproject.Rows.Count + 1);
}
for (int i = 0; i < dpt.Rows.Count; i++)
{
DataRow dpr = dpt.Rows[i];
dgvproject.Rows[i].Cells["item_id"].Value = CommonCtrl.IsNullToString(dpr["item_id"]);
dgvproject.Rows[i].Cells["three_warranty"].Value = CommonCtrl.IsNullToString(dpr["three_warranty"]) == "1" ? "是" : "否";
dgvproject.Rows[i].Cells["man_hour_type"].Value = CommonCtrl.IsNullToString(dpr["man_hour_type"]);
dgvproject.Rows[i].Cells["item_no"].Value = CommonCtrl.IsNullToString(dpr["item_no"]);
dgvproject.Rows[i].Cells["item_name"].Value = CommonCtrl.IsNullToString(dpr["item_name"]);
dgvproject.Rows[i].Cells["item_type"].Value = CommonCtrl.IsNullToString(dpr["item_type"]);
dgvproject.Rows[i].Cells["man_hour_quantity"].Value = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dpr["man_hour_quantity"]), 1);
dgvproject.Rows[i].Cells["man_hour_norm_unitprice"].Value = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dpr["man_hour_norm_unitprice"]), 2);
dgvproject.Rows[i].Cells["remarks"].Value = CommonCtrl.IsNullToString(dpr["remarks"]);
dgvproject.Rows[i].Cells["sum_money_goods"].Value = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dpr["sum_money_goods"]), 2);
dgvproject.Rows[i].Cells["member_discount"].Value = CommonCtrl.IsNullToString(dpr["member_discount"]);
dgvproject.Rows[i].Cells["member_price"].Value = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dpr["member_price"]), 2);
dgvproject.Rows[i].Cells["member_sum_money"].Value = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dpr["member_sum_money"]), 2);
}
}
#endregion
#region 维修用料数据
//维修用料数据
decimal dcMmoney = 0;
DataTable dmt = DBHelper.GetTable("维修用料数据", "tb_maintain_material_detail", "*", string.Format(" maintain_id='{0}'", strRepairId), "", "");
if (dmt.Rows.Count > 0)
{
if (dmt.Rows.Count > dgvMaterials.Rows.Count)
{
dgvMaterials.Rows.Add(dmt.Rows.Count - dgvMaterials.Rows.Count + 1);
}
for (int i = 0; i < dmt.Rows.Count; i++)
{
DataRow dmr = dmt.Rows[i];
dgvMaterials.Rows[i].Cells["material_id"].Value = CommonCtrl.IsNullToString(dmr["material_id"]);
dgvMaterials.Rows[i].Cells["parts_code"].Value = CommonCtrl.IsNullToString(dmr["parts_code"]);
dgvMaterials.Rows[i].Cells["parts_name"].Value = CommonCtrl.IsNullToString(dmr["parts_name"]);
dgvMaterials.Rows[i].Cells["norms"].Value = CommonCtrl.IsNullToString(dmr["norms"]);
dgvMaterials.Rows[i].Cells["unit"].Value = CommonCtrl.IsNullToString(dmr["unit"]);
dgvMaterials.Rows[i].Cells["quantity"].Value = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dmr["quantity"]), 1);
dgvMaterials.Rows[i].Cells["unit_price"].Value = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dmr["unit_price"]), 2);
dgvMaterials.Rows[i].Cells["Mmember_discount"].Value = CommonCtrl.IsNullToString(dmr["member_discount"]);
dgvMaterials.Rows[i].Cells["Mmember_price"].Value = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dmr["member_price"]), 2);
dgvMaterials.Rows[i].Cells["sum_money"].Value = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dmr["sum_money"]), 2);
dgvMaterials.Rows[i].Cells["drawn_no"].Value = CommonCtrl.IsNullToString(dmr["drawn_no"]);
dgvMaterials.Rows[i].Cells["vehicle_brand"].Value = CommonCtrl.IsNullToString(dmr["vehicle_brand"]);
dgvMaterials.Rows[i].Cells["Mthree_warranty"].Value = CommonCtrl.IsNullToString(dmr["three_warranty"]) == "1" ? "是" : "否";
dgvMaterials.Rows[i].Cells["Mremarks"].Value = CommonCtrl.IsNullToString(dmr["remarks"]);
dgvMaterials.Rows[i].Cells["whether_imported"].Value = CommonCtrl.IsNullToString(dmr["whether_imported"]) == "1" ? "是" : "否";
}
}
#endregion
#region 其他项目收费数据
//其他项目收费数据
decimal doMmoney = 0;
DataTable dot = DBHelper.GetTable("其他项目收费数据", "tb_maintain_other_toll", "*", string.Format(" maintain_id='{0}'", strRepairId), "", "");
if (dot.Rows.Count > 0)
{
if (dot.Rows.Count > dgvOther.Rows.Count)
{
dgvOther.Rows.Add(dot.Rows.Count - dgvOther.Rows.Count + 1);
}
for (int i = 0; i < dot.Rows.Count; i++)
{
DataRow dor = dot.Rows[i];
dgvOther.Rows[i].Cells["toll_id"].Value = CommonCtrl.IsNullToString(dor["toll_id"]);
dgvOther.Rows[i].Cells["Osum_money"].Value = ControlsConfig.SetNewValue(CommonCtrl.IsNullToString(dor["sum_money"]), 2);
dgvOther.Rows[i].Cells["Oremarks"].Value = CommonCtrl.IsNullToString(dor["remarks"]);
dgvOther.Rows[i].Cells["cost_types"].Value = GetDicName(CommonCtrl.IsNullToString(dor["cost_types"]));
}
}
#endregion
#region 附件信息数据
//附件信息数据
ucAttr.TableName = "tb_maintain_info";
ucAttr.TableNameKeyValue = strRepairId;
ucAttr.BindAttachment();
#endregion
#endregion
}
}
public GameLeaveController(ILogger <GameLeaveController> logger, DataSources dataSources)
{
_logger = logger;
_dataAccess = dataSources.DataAccess;
}
public bool HasEntry(int dataSourceId)
{
return(DataSources.ContainsKey(dataSourceId));
}
private SymbolicValue(IEnumerable <ILInstruction> dataSources)
{
DataSources.UnionWith(dataSources);
}
