protected void btnSave_Click(object sender, EventArgs e) { try { if (fup.HasFiles) { string upload_folder_path = "~/PatientDocument/" + Session["PatientId"]; if (!Directory.Exists(upload_folder_path)) { Directory.CreateDirectory(Server.MapPath(upload_folder_path)); } foreach (HttpPostedFile uploadedFile in fup.PostedFiles) { string filename = uploadedFile.FileName; string doa = CommonConvert.DateFormat(ViewState["doa"].ToString()); //string filename = System.DateTime.Now.Millisecond.ToString() + "_" + uploadedFile.FileName; string query = "insert into tblPatientDocument values('" + filename + "','" + System.DateTime.Now.ToString() + "','" + upload_folder_path + "/" + filename + "'," + Session["PatientId"].ToString() + ",'" + Request["DOA"].ToString() + "')"; db.executeQuery(query); uploadedFile.SaveAs(System.IO.Path.Combine(Server.MapPath(upload_folder_path), filename)); // listofuploadedfiles.Text += String.Format("{0}<br />", uploadedFile.FileName); } } getData(); } catch (Exception ex) { } }
public Runner() { _connectinString = ConfigurationManager.AppSettings["ConnectionString"]; _producer = new ProducerBasic(RabbitMQManager.GetRabbitMQServer("rabbitMqCrlProperties"), "Product.AdsScore.Deleted"); MAX_HOUR_LOOP = CommonConvert.Obj2Int(ConfigurationManager.AppSettings["MAX_HOUR_LOOP"]); HOUR_RUN = CommonConvert.Obj2Int(ConfigurationManager.AppSettings["HOUR_RUN"]); }
private void viewPropertiesToolStripMenuItem_Click(object sender, EventArgs e) { long RootId = CommonConvert.Obj2Int64(this.gridView1.GetRowCellValue(this.gridView1.FocusedRowHandle, "ID").ToString()); FrmProperties frm = new FrmProperties(RootId); frm.Text = this.gridView1.GetRowCellValue(this.gridView1.FocusedRowHandle, "Name").ToString(); frm.MdiParent = this; frm.Show(); }
public void ShouldConvertForNumberDotAndCommand() { var y = CommonConvert.ConvertStringToPrice("12.123.323,23"); Assert.AreEqual(12123323, 23, y); var y1 = CommonConvert.ConvertStringToPrice("12,123,323.23"); Assert.AreEqual(12123323, 23, y1); }
public bool RunQuery(string query, CommandType commandType, SqlParameter[] arPara, bool WaiRunOK = false, int TryRun = 0) { int iRun = 0; while (true) { try { this.command.CommandType = commandType; this.command.CommandText = query; this.command.Parameters.Clear(); if (arPara != null) { this.command.Parameters.AddRange(arPara); } if (this.command.Connection.State == ConnectionState.Closed) { this.command.Connection.Open(); } this.command.ExecuteNonQuery(); return(true); } catch (SqlException ex) { if (ex.Number == -2) { log.Error(ex.Message); iRun++; if (WaiRunOK == false && iRun >= TryRun) { return(false); } } else { log.Info(ex.Message + ex.StackTrace + query + CommonConvert.ArParaToString(arPara)); return(false); } } catch (Exception ex) { if (!WaiRunOK) { log.ErrorFormat("Exception sql run" + ex.Message + ex.StackTrace + command.CommandText); return(false); } else { Thread.Sleep(10000); } } } }
private string DownloadHtml(JobCrlProperties jobDownloadHtml) { WebExceptionStatus w = WebExceptionStatus.ConnectFailure; var html = this._downloadHtml.GetHtml(jobDownloadHtml.DetailUrl, 45, 2, out w); html = CommonConvert.RemoveScripTag(html); html = CommonConvert.RemoveCommentXML(html); return(html); }
public void ProcessAllIdProductByCompany(string domain, EventHandler <long> eventHandler) { string query = string.Format("select id from product_properties.html_id where domain = '{0}';", domain); foreach (var VARIABLE in _session.Execute(query, 1000)) { long productIds = CommonConvert.Obj2Int64(VARIABLE.GetValue(typeof(long), "id")); if (productIds > 0) { eventHandler(this, productIds); } } }
protected override void OnStart(string[] args) { _workerCount = CommonConvert.Obj2Int(ConfigurationManager.AppSettings["WorkerCount"]); for (var i = 0; i < _workerCount; i++) { var workerTask = new Task(() => { WorkerLog wk = new WorkerLog(); wk.StartConsume(); Console.ReadLine(); }); workerTask.Start(); } }
public T ConvertByteArrayToObject <T, TK, TP>(byte[] bytes, TK obj, TP parentObj) { //获取数据包总大小 DataSize = parentObj.ExtGetPropertyValueByName <TP, short>(_innerPropertyName0) * _singleDataSize; if (!string.IsNullOrEmpty(_innerPropertyName1)) { DataSize += parentObj.ExtGetPropertyValueByName <TP, short>(_innerPropertyName1) * _singleDataSize; } //截取需要的字节数组 var allBytes = new byte[DataSize]; Array.Copy(bytes, 0, allBytes, 0, DataSize); //获取集合里面的参数类型(默认都只有一种参数类型) var type = obj.GetType(); var argument = type.GetGenericArguments()[0]; //获取单个数据包的总个数 var numPackages = DataSize / _singleDataSize; for (int i = 0; i < numPackages; i++) { //创建集合里面的对应参数类型实例 var instance = argument.ExtCreateInstance <object>(); if (instance != null) { var startLocation = i * _singleDataSize; var bodys = new List <Tuple <PropertyInfo, IBodyDataPackageAttribute, object> >(); //读取当前类包含的所有特性集合 CommonConvert.ReadChildProperty(instance.GetType().GetProperties(), instance, ref bodys); //排序 var sl = bodys.OrderBy(s => s.Item2.SortLocation); //对每个属性赋值 foreach (var packageAttribute in sl) { var newBytes = new byte[packageAttribute.Item2.DataSize]; Array.Copy(allBytes, startLocation, newBytes, 0, newBytes.Length); startLocation += packageAttribute.Item2.DataSize; packageAttribute.Item1.SetValue(instance, packageAttribute.Item2.ConvertByteArrayToObject <object, PropertyInfo>(newBytes, packageAttribute.Item1), null); //instance.ExtSetPropertyValue(packageAttribute.Item2.ConvertByteArrayToObject<object, PropertyInfo>(newBytes, packageAttribute.Item1), packageAttribute.Item1); } //像集合中添加一条数据 type.InvokeMember("Add", BindingFlags.InvokeMethod | BindingFlags.Public | BindingFlags.Instance, null, obj, new[] { instance }); } } return((T)(object)obj); }
public void repositoryItemSearchLookUpEdit1_EditValueChanged(object sender, EventArgs e) { long PropertyID = CommonConvert.Obj2Int64((this.gridView1.GetRow(this.gridView1.FocusedRowHandle) as DataRowView)["ID"]); var searchLookUpEdit = sender as SearchLookUpEdit; if (searchLookUpEdit == null) { return; } DevExpress.XtraEditors.Repository.RepositoryItemSearchLookUpEdit riSearchLookUpEdit = searchLookUpEdit.Properties as DevExpress.XtraEditors.Repository.RepositoryItemSearchLookUpEdit; var rowByKeyValue = riSearchLookUpEdit.View.GetFocusedRowCellValue("ID"); long PropertyRootID = CommonConvert.Obj2Int64(rowByKeyValue); this.propertiesMerchantTableAdapter.Connection.ConnectionString = ConfigurationManager.AppSettings["MerchantProperties"]; this.propertiesMerchantTableAdapter.Update_RootProperty(PropertyRootID, PropertyID); }
public void FattanToSql(PropertyProduct propertyData) { foreach (var VARIABLE in propertyData.Properties) { string propertyName = propertyData.Category + ":" + VARIABLE.Key; long propertyID = CommonConvert.CrcProductID(propertyName); bool bOk = this.sqlDbProperties.RunQuery("sp_Property_Ins", CommandType.StoredProcedure, new[] { SqlDb.CreateParamteterSQL("CategoryID", propertyData.CategoryId, SqlDbType.BigInt), SqlDb.CreateParamteterSQL("CategoryName", propertyData.Category, SqlDbType.NVarChar), SqlDb.CreateParamteterSQL("ProperyID", propertyID, SqlDbType.BigInt), SqlDb.CreateParamteterSQL("ProperyValue", VARIABLE.Value, SqlDbType.NVarChar), SqlDb.CreateParamteterSQL("CompanyID", propertyData.CompanyID, SqlDbType.BigInt), SqlDb.CreateParamteterSQL("ProductID", propertyData.ProductId, SqlDbType.BigInt), SqlDb.CreateParamteterSQL("PropertyName", propertyName, SqlDbType.NVarChar), }); } }
public Entity.ConfigProperty GetConfig(string domain) { DataTable tbl = this._sqlDbProduct.GetTblData(@" SELECT TOP 1 c.[Id] ,c.[CompanyId] ,c.[TypeLayout] ,c.[XPath] ,c.[JSonOtherConfig] ,c.[JSonOtherConfigDemo] ,c.UrlTest , cf.CategoryXPath , co.Domain , cf.RemoveLastItemClassification , cf.TimeDelay FROM [dbo].[Configuration_Property] c INNER JOIN Configuration cf ON cf.CompanyID = c.CompanyId INNER JOIN Company co ON co.Id = cf.CompanyId Where co.Domain = @CompanyId" , CommandType.Text, new SqlParameter[] { SqlDb.CreateParamteterSQL("@CompanyId", domain, SqlDbType.NVarChar) }); if (tbl.Rows.Count > 0) { var row = tbl.Rows[0]; return(new ConfigProperty() { CategoryXPath = CommonConvert.Obj2String(row["CategoryXPath"]), CompanyId = CommonConvert.Obj2Int64(row["CompanyId"]), JSonOtherConfig = CommonConvert.Obj2String(row["JSonOtherConfig"]), TypeLayout = CommonConvert.Obj2Int(row["TypeLayout"]), XPath = CommonConvert.Obj2String(row["XPath"]), UrlTest = CommonConvert.Obj2String(row["UrlTest"]), Domain = CommonConvert.Obj2String(row["Domain"]), RemoveLastItemClassification = CommonConvert.Obj2Bool(row["RemoveLastItemClassification"]), TimeDelay = CommonConvert.Obj2Int(row["TimeDelay"]) }); } else { return(null); } }
public async void UpdateCategoryId() { var filter = new BsonDocument(); var count = 0; using (var cursor = await _colPropertiesData.FindAsync(filter)) { while (await cursor.MoveNextAsync()) { var batch = cursor.Current; foreach (var document in batch) { var propertyData = BsonSerializer.Deserialize <PropertyProduct>(document); if (propertyData != null) { if (propertyData.ProductId == 0) { this._colPropertiesData.DeleteOne(document); this._log.Info(string.Format("Delete item")); } else { propertyData.CategoryId = CommonConvert.CrcProductID(propertyData.Category); var update = Builders <BsonDocument> .Update .Set("category_id", propertyData.CategoryId) .CurrentDate("lastModified"); this._colPropertiesData.UpdateOne(document, update); _log.Info(string.Format("Updated for item {0} {1}", propertyData._id, propertyData.ProductId)); } } else { _log.Info("ProductData null"); } _log.Info(string.Format("Process {0} items ", count)); count++; } } } }
public void ConvertObjectToByteArray <T>(T obj) { if (obj is ICollection) { var collection = obj as ICollection; var dataAll = new byte[0]; foreach (var coll in collection) { //获取当前实体类转换成的字节数组 var data = CommonConvert.GetObjData(coll); //创建新的数组进行合并并赋值给变量保存 var bytes = new byte[data.Length + dataAll.Length]; dataAll.CopyTo(bytes, 0); data.CopyTo(bytes, dataAll.Length); dataAll = bytes; } DataSize = dataAll.Length; _dataPackage = dataAll; } }
public void MapData(string domain) { this.database = RedisManager.GetRedisServer("redisPropertiesProduct").GetDatabase(1); this._cacheMan = CacheManager.GetCacheServer("redisPropertiesProduct"); int i = 0; string PropertyName = ""; string PropertyValue = ""; long PropertyID = 0; long companyID = LibExtra.CommonConvert.Obj2Int64(this.sqldb.GetTblData(string.Format("Select ID from Company where Domain = '{0}'", domain)).Rows[0]["ID"]); this.sqldb.ProcessDataTableLarge(string.Format("select ID,ClassificationID from product where company = {0} order by ID", companyID), 1000, (obj, iRow) => { long ProductID = CommonConvert.Obj2Int64(obj["ID"]); long ClassificationID = CommonConvert.Obj2Int64(obj["ClassificationID"]); string ClassificationName = this.sqldb.GetTblData(string.Format("Select Name from Classification where ID = {0}", ClassificationID)).Rows[0]["Name"].ToString(); var lstProperties = _cacheMan.Get <List <KeyValuePair <string, string> > >("prs:" + ProductID, true); if (lstProperties != null && lstProperties.Count > 0) { foreach (var item in lstProperties) { PropertyName = ClassificationName + ":" + item.Key.ToString(); PropertyValue = item.Value.ToString(); PropertyID = CommonConvert.CrcProductID(PropertyName); } string querytest = string.Format("Insert into PropertyItem (PropertyID, ProductID, Value) values ({0},{1},N'{2}')", PropertyID, ProductID, PropertyValue); sqldbProperties.RunQuery(string.Format("Insert into Category (ID, Name, CompanyID) values ({0},N'{1}',{2})", ClassificationID, ClassificationName, companyID), CommandType.Text, new System.Data.SqlClient.SqlParameter[] { }); sqldbProperties.RunQuery(string.Format("Insert into Properties (ID,CategoryID, Name, CompanyID) values ({0},{1},N'{2}',{3})", PropertyID, ClassificationID, PropertyName, companyID), CommandType.Text, new System.Data.SqlClient.SqlParameter[] { }); sqldbProperties.RunQuery(string.Format("Insert into Product_PropertyCategory (ID, CompanyId, Name,Property_Id,CategoryID) values ({0},{1},N'{2}',{3},{4})", ProductID, companyID, PropertyName, PropertyID, ClassificationID), CommandType.Text, new System.Data.SqlClient.SqlParameter[] { }); sqldbProperties.RunQuery(querytest, CommandType.Text, new System.Data.SqlClient.SqlParameter[] { }); } i++; log.InfoFormat("{0} {1}", i, ProductID); return(true); }); }
public PropertyProduct ParseData(HtmlDocument document) { PropertyProduct propertyData = new PropertyProduct(); propertyData.Category = ""; propertyData.Domain = _configPropertyNomal.Domain; propertyData.CategoryId = CommonConvert.CrcProductID(propertyData.Category); var nodeRows = document.DocumentNode.SelectNodes(_configPropertyNomal.XPath); dynamic configOtherData = JObject.Parse(_configPropertyNomal.JSonOtherConfig); string colH = configOtherData.IndexColHeader.ToString(); string colB = configOtherData.IndexColData.ToString(); if (nodeRows != null) { foreach (var variable in nodeRows) { var nodeCell = variable.SelectNodes("./td"); if (nodeCell != null) { try { if (!string.IsNullOrEmpty(nodeCell[Convert.ToInt32(colH)].InnerText.Trim()) && !string.IsNullOrEmpty(nodeCell[Convert.ToInt32(colB)].InnerText.Trim())) { propertyData.Properties.Add( nodeCell[Convert.ToInt32(colH)].InnerText.Trim(), nodeCell[Convert.ToInt32(colB)].InnerText.Trim()); } } catch (Exception ex) { // ignored } } } } return(propertyData); }
public void ProcessProduct(string domain, EventHandler <Product> eventHandler) { long companyID = CommonConvert.Obj2Int64(this._sqlDb.GetTblData((string.Format("select ID from Company where Domain = '{0}'", domain))).Rows[0]["ID"]); this._sqlDb.ProcessDataTableLarge(string.Format(@" select --top 1000 pt.ID, pt.DetailUrl from Product pt where pt.Company = {0} order by pt.ID ", companyID), 1000, (obj, iRow) => { eventHandler(this, new Product() { Id = Convert.ToInt64(obj["ID"]), DetailUrl = Convert.ToString(obj["DetailUrl"]), ClassificationId = 0, // CommonConvert.Obj2Int64(obj["ClassificationID"]), Classification = "" //Convert.Obj2String(obj["Classification"]) }); return(true); }); }
private DataGridColumn GetDataGridColumn(GridItem gItem) { Binding bding = new Binding(); if (!string.IsNullOrEmpty(gItem.PropertyName)) { bding.Mode = BindingMode.TwoWay; bding.Path = new PropertyPath(gItem.PropertyName); if (gItem.ReferenceDataInfo != null) { IValueConverter converter = CommonFunction.GetIValueConverter(gItem.ReferenceDataInfo.Type); bding.Converter = converter; } else if (gItem.PropertyName.Contains("MONEY")) { IValueConverter converter = new CurrencyConverter(); bding.Converter = converter; } else { IValueConverter converter = new CommonConvert(gItem); bding.Converter = converter; } } else { System.Diagnostics.Debug.WriteLine(""); } DataGridColumn dgc = null; switch (gItem.CType) { case ControlType.CheckBox: DataGridCheckBoxColumn dgcc = new DataGridCheckBoxColumn(); dgcc.IsThreeState = false; dgcc.Binding = bding; dgc = dgcc; break; case ControlType.Label: if (gItem.ReferenceDataInfo != null) { DataGridReferenceColumn dgrc = new DataGridReferenceColumn(); dgrc.Binding = bding; dgrc.DisplayMemberPath = "Text"; dgc = dgrc; } else { DataGridTextColumn dgtc = new MyDataGridTextColumn(gItem); dgtc.Binding = bding; dgc = dgtc; } break; case ControlType.Combobox: DataGridComboBoxColumn dgcbc = new DataGridComboBoxColumn(); if (gItem.ReferenceDataInfo != null) { IList <ITextValueItem> list = DataCore.GetRefData(gItem.ReferenceDataInfo.Type); dgcbc.ItemsSource = list; } dgcbc.DisplayMemberPath = "Text"; dgcbc.Binding = bding; dgc = dgcbc; break; case ControlType.TreeViewItem: DataGridIconColumn dgtvic = new DataGridIconColumn(); dgtvic.Binding = bding; dgc = dgtvic; break; case ControlType.Templete: //"<StackPanel Orientation="Horizontal"><smtx:ImageButton x:Name="myDelete" Click="Delete_Click"/></StackPanel>" var gridXCs = new XElementString("StackPanel", new XAttributeString("Orientation", "Horizontal")); DataGridTemplateColumn dtc = new DataGridTemplateColumn(); dtc.CellTemplate = DataTemplateHelper.GetDataTemplate(gridXCs); dgc = dtc; break; } return(dgc); }
private void bindData() { DBHelperClass db = new DBHelperClass(); string query = ""; query = "select top 1 * from tblPatientIEDetailPage2 where PatientIE_ID=" + Session["PatientIE_ID"].ToString(); DataSet ds = db.selectData(query); if (ds.Tables[0].Rows.Count > 0) { //chk_seizures.Checked = ds.Tables[0].Rows[0]["Seizures"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Seizures"].ToString()) : false; //chk_chest_pain.Checked = ds.Tables[0].Rows[0]["ChestPain"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["ChestPain"].ToString()) : false; //chk_shortness_of_breath.Checked = ds.Tables[0].Rows[0]["ShortnessOfBreath"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["ShortnessOfBreath"].ToString()) : false; //chk_jaw_pain.Checked = ds.Tables[0].Rows[0]["Jawpain"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Jawpain"].ToString()) : false; //chk_abdominal_pain.Checked = ds.Tables[0].Rows[0]["AbdominalPain"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["AbdominalPain"].ToString()) : false; //chk_fever.Checked = ds.Tables[0].Rows[0]["Fevers"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Fevers"].ToString()) : false; //chk_diarrhea.Checked = ds.Tables[0].Rows[0]["Diarrhea"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Diarrhea"].ToString()) : false; //chk_bowel_bladder.Checked = ds.Tables[0].Rows[0]["Bowel"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Bowel"].ToString()) : false; //chk_blurred.Checked = ds.Tables[0].Rows[0]["DoubleVision"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["DoubleVision"].ToString()) : false; //chk_recent_wt.Checked = ds.Tables[0].Rows[0]["RecentWeightloss"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["RecentWeightloss"].ToString()) : false; //chk_episodic_ligth.Checked = ds.Tables[0].Rows[0]["Episodic"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Episodic"].ToString()) : false; //chk_rashes.Checked = ds.Tables[0].Rows[0]["Rashes"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Rashes"].ToString()) : false; //chk_hearing_loss.Checked = ds.Tables[0].Rows[0]["HearingLoss"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["HearingLoss"].ToString()) : false; //chk_sleep_disturbance.Checked = ds.Tables[0].Rows[0]["NightSweats"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["NightSweats"].ToString()) : false; //chk_depression.Checked = ds.Tables[0].Rows[0]["Depression"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Depression"].ToString()) : false; //chk_bloodinurine.Checked = ds.Tables[0].Rows[0]["dloodinurine"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["dloodinurine"].ToString()) : false; LTricepstxt.Text = Convert.ToString(ds.Tables[0].Rows[0]["DTRtricepsLeft"]); RTricepstxt.Text = Convert.ToString(ds.Tables[0].Rows[0]["DTRtricepsRight"]); LBicepstxt.Text = Convert.ToString(ds.Tables[0].Rows[0]["DTRBicepsLeft"]); RBicepstxt.Text = Convert.ToString(ds.Tables[0].Rows[0]["DTRBicepsRight"]); RBrachioradialis.Text = Convert.ToString(ds.Tables[0].Rows[0]["DTRBrachioRight"]); LBrachioradialis.Text = Convert.ToString(ds.Tables[0].Rows[0]["DTRBrachioLeft"]); LKnee.Text = Convert.ToString(ds.Tables[0].Rows[0]["DTRKneeLeft"]); RKnee.Text = Convert.ToString(ds.Tables[0].Rows[0]["DTRKneeRight"]); LAnkle.Text = Convert.ToString(ds.Tables[0].Rows[0]["DTRAnkleLeft"]); RAnkle.Text = Convert.ToString(ds.Tables[0].Rows[0]["DTRAnkleRight"]); UExchk.Checked = ds.Tables[0].Rows[0]["UEdtr"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["UEdtr"].ToString()) : false; chkPinPrick.Checked = ds.Tables[0].Rows[0]["Pinprick"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Pinprick"].ToString()) : false; chkLighttouch.Checked = ds.Tables[0].Rows[0]["Lighttouch"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Lighttouch"].ToString()) : false; txtSensory.Text = Convert.ToString(ds.Tables[0].Rows[0]["Sensory"]); LESen_Click.Checked = ds.Tables[0].Rows[0]["LEsen"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["LEsen"].ToString()) : false; TextBox4.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEL3Right"]); txtDMTL3.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEL3Left"]); TextBox6.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEL4Right"]); TextBox5.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEL4Left"]); TextBox8.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEL5Right"]); TextBox7.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEL5Left"]); TextBox10.Text = Convert.ToString(ds.Tables[0].Rows[0]["LES1Left"]); TextBox21.Text = Convert.ToString(ds.Tables[0].Rows[0]["LES1Right"]); TextBox25.Text = Convert.ToString(ds.Tables[0].Rows[0]["LELumberParaspinalsRight"]); TextBox24.Text = Convert.ToString(ds.Tables[0].Rows[0]["LELumberParaspinalsLeft"]); UESen_Click.Checked = ds.Tables[0].Rows[0]["UEsen"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["UEsen"].ToString()) : false; TextBox9.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEC5Left"]); txtUEC5Right.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEC5Right"]); TextBox11.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEC6Left"]); TextBox12.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEC6Right"]); TextBox13.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEC7Left"]); TextBox14.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEC7Right"]); TextBox15.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEC8Left"]); TextBox16.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEC8Right"]); TextBox18.Text = Convert.ToString(ds.Tables[0].Rows[0]["UET1Right"]); TextBox17.Text = Convert.ToString(ds.Tables[0].Rows[0]["UET1Left"]); TextBox20.Text = Convert.ToString(ds.Tables[0].Rows[0]["UECervicalParaspinalsRight"]); TextBox19.Text = Convert.ToString(ds.Tables[0].Rows[0]["UECervicalParaspinalsLeft"]); // cboHoffmanexam.SelectedValue = Convert.ToString(ds.Tables[0].Rows[0]["HoffmanExam"]); // chkStocking.Checked = ds.Tables[0].Rows[0]["Stocking"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Stocking"].ToString()) : false; //chkGlove.Checked = ds.Tables[0].Rows[0]["Glove"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Glove"].ToString()) : false; LEmmst.Checked = ds.Tables[0].Rows[0]["LEmmst"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["LEmmst"].ToString()) : false; TextBox23.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEHipFlexionRight"]); TextBox22.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEHipFlexionLeft"]); TextBox41.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEHipAbductionRight"]); TextBox40.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEHipAbductionLeft"]); TextBox27.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEKneeExtensionRight"]); TextBox26.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEKneeExtensionLeft"]); TextBox43.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEKneeFlexionRight"]); TextBox42.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEKneeFlexionLeft"]); TextBox29.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEAnkleDorsiRight"]); TextBox28.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEAnkleDorsiLeft"]); TextBox45.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEAnklePlantarRight"]); TextBox44.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEAnklePlantarLeft"]); TextBox47.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEAnkleExtensorRight"]); TextBox46.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEAnkleExtensorLeft"]); UEmmst.Checked = ds.Tables[0].Rows[0]["UEmmst"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["UEmmst"].ToString()) : false; TextBox31.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEShoulderAbductionRight"]); TextBox30.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEShoulderAbductionLeft"]); TextBox49.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEShoulderFlexionRight"]); TextBox48.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEShoulderFlexionLeft"]); TextBox33.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEElbowExtensionRight"]); TextBox32.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEElbowExtensionLeft"]); TextBox51.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEElbowFlexionRight"]); TextBox50.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEElbowFlexionLeft"]); TextBox53.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEElbowSupinationRight"]); TextBox52.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEElbowSupinationLeft"]); TextBox55.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEElbowPronationRight"]); TextBox54.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEElbowPronationLeft"]); TextBox37.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEWristFlexionRight"]); TextBox36.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEWristFlexionLeft"]); TextBox57.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEWristExtensionRight"]); TextBox56.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEWristExtensionLeft"]); TextBox39.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEHandGripStrengthRight"]); TextBox38.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEHandGripStrengthLeft"]); TextBox59.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEHandFingerAbductorsRight"]); TextBox58.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEHandFingerAbductorsLeft"]); txtIntactExcept.Text = Convert.ToString(ds.Tables[0].Rows[0]["intactexcept"]); LEdtr.Checked = ds.Tables[0].Rows[0]["LEdtr"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["LEdtr"].ToString()) : false; } else { PopulateUIDefaults(); } query = "select * from tblPage3HTMLContent where PatientIE_ID=" + Session["PatientIE_ID"].ToString(); ds = db.selectData(query); if (ds.Tables[0].Rows.Count > 0) { divHtml.InnerHtml = ds.Tables[0].Rows[0]["HTMLContent"].ToString(); divtopHtml.InnerHtml = ds.Tables[0].Rows[0]["topSectionHTML"].ToString(); } else { bindHtml(); } query = "Select * from tblPatientIEDetailPage3 WHERE PatientIE_ID = " + Session["PatientIE_ID"].ToString(); ds = db.selectData(query); if (ds.Tables[0].Rows.Count > 0) { cboGAIT.Text = ds.Tables[0].Rows[0]["GAIT"].ToString().Trim(); cboAmbulates.Text = ds.Tables[0].Rows[0]["Ambulates"].ToString().Trim(); chkFootslap.Checked = CommonConvert.ToBoolean(ds.Tables[0].Rows[0]["Footslap"].ToString()); chkKneehyperextension.Checked = CommonConvert.ToBoolean(ds.Tables[0].Rows[0]["Kneehyperextension"].ToString()); chkUnabletohealwalk.Checked = CommonConvert.ToBoolean(ds.Tables[0].Rows[0]["Unabletohealwalk"].ToString()); chkUnabletotoewalk.Checked = CommonConvert.ToBoolean(ds.Tables[0].Rows[0]["Unabletotoewalk"].ToString()); txtOther.Text = ds.Tables[0].Rows[0]["Other"].ToString().Trim(); } }
public void PopulateUIDefaults() { XmlDocument xmlDoc = new XmlDocument(); string filename; //filename = "~/Template/Default_" + Session["uname"].ToString() + ".xml"; //if (File.Exists(Server.MapPath(filename))) //{ xmlDoc.Load(Server.MapPath(filename)); } //else { xmlDoc.Load(Server.MapPath("~/Template/Default_Admin.xml")); } xmlDoc.Load(Server.MapPath("~/Template/Default_Admin.xml")); XmlNodeList nodeList = xmlDoc.DocumentElement.SelectNodes("/Defaults/IEPage3"); foreach (XmlNode node in nodeList) { if (cboGAIT.Text == "") { cboGAIT.Text = node.SelectSingleNode("GAIT") == null?cboGAIT.Text.ToString().Trim() : node.SelectSingleNode("GAIT").InnerText; } if (cboAmbulates.Text == "") { cboAmbulates.Text = node.SelectSingleNode("Ambulates") == null?cboAmbulates.Text.ToString().Trim() : node.SelectSingleNode("Ambulates").InnerText; } chkFootslap.Checked = node.SelectSingleNode("Footslap") == null ? chkFootslap.Checked : CommonConvert.ToBoolean(node.SelectSingleNode("Footslap").InnerText); chkKneehyperextension.Checked = node.SelectSingleNode("Kneehyperextension") == null ? chkKneehyperextension.Checked : CommonConvert.ToBoolean(node.SelectSingleNode("Kneehyperextension").InnerText); chkUnabletohealwalk.Checked = node.SelectSingleNode("Unabletohealwalk") == null ? chkUnabletohealwalk.Checked : CommonConvert.ToBoolean(node.SelectSingleNode("Unabletohealwalk").InnerText); chkUnabletotoewalk.Checked = node.SelectSingleNode("Unabletotoewalk") == null ? chkUnabletotoewalk.Checked : CommonConvert.ToBoolean(node.SelectSingleNode("Unabletotoewalk").InnerText); if (txtOther.Text == "") { txtOther.Text = node.SelectSingleNode("Other") == null?txtOther.Text.ToString().Trim() : node.SelectSingleNode("Other").InnerText; } } xmlDoc = new XmlDocument(); xmlDoc.Load(Server.MapPath("~/Template/Default_Admin.xml")); nodeList = xmlDoc.DocumentElement.SelectNodes("/Defaults/IEPage2"); foreach (XmlNode node in nodeList) { txtIntactExcept.Text = node.SelectSingleNode("intactexcept").InnerText; LEdtr.Checked = node.SelectSingleNode("LEdtr") == null ? LEdtr.Checked : Convert.ToBoolean(node.SelectSingleNode("LEdtr").InnerText); // chk_depression.Checked = node.SelectSingleNode("Depression") == null ? chk_depression.Checked : Convert.ToBoolean(node.SelectSingleNode("Depression").InnerText); LTricepstxt.Text = node.SelectSingleNode("DTRtricepsLeft").InnerText; RTricepstxt.Text = node.SelectSingleNode("DTRtricepsRight").InnerText; LBicepstxt.Text = node.SelectSingleNode("DTRBicepsLeft").InnerText; RBicepstxt.Text = node.SelectSingleNode("DTRBicepsRight").InnerText; RBrachioradialis.Text = node.SelectSingleNode("DTRBrachioRight").InnerText; LBrachioradialis.Text = node.SelectSingleNode("DTRBrachioLeft").InnerText; LKnee.Text = node.SelectSingleNode("DTRKneeLeft").InnerText; RKnee.Text = node.SelectSingleNode("DTRKneeRight").InnerText; LAnkle.Text = node.SelectSingleNode("DTRAnkleLeft").InnerText; RAnkle.Text = node.SelectSingleNode("DTRAnkleRight").InnerText; UExchk.Checked = node.SelectSingleNode("UEdtr") == null ? UExchk.Checked : Convert.ToBoolean(node.SelectSingleNode("UEdtr").InnerText); chkPinPrick.Checked = node.SelectSingleNode("Pinprick") == null ? chkPinPrick.Checked : Convert.ToBoolean(node.SelectSingleNode("Pinprick").InnerText); chkLighttouch.Checked = node.SelectSingleNode("Lighttouch") == null ? chkPinPrick.Checked : Convert.ToBoolean(node.SelectSingleNode("Lighttouch").InnerText); txtSensory.Text = node.SelectSingleNode("Sensory").InnerText; LESen_Click.Checked = node.SelectSingleNode("LEsen") == null ? chkPinPrick.Checked : Convert.ToBoolean(node.SelectSingleNode("LEsen").InnerText); TextBox4.Text = node.SelectSingleNode("LEL3Right").InnerText; txtDMTL3.Text = node.SelectSingleNode("LEL3Left").InnerText; TextBox6.Text = node.SelectSingleNode("LEL4Right").InnerText; TextBox5.Text = node.SelectSingleNode("LEL4Left").InnerText; TextBox8.Text = node.SelectSingleNode("LEL5Right").InnerText; TextBox7.Text = node.SelectSingleNode("LEL5Left").InnerText; TextBox10.Text = node.SelectSingleNode("LES1Left").InnerText; TextBox21.Text = node.SelectSingleNode("LES1Right").InnerText; TextBox25.Text = node.SelectSingleNode("LELumberParaspinalsRight").InnerText; TextBox24.Text = node.SelectSingleNode("LELumberParaspinalsLeft").InnerText; UESen_Click.Checked = node.SelectSingleNode("UEsen") == null ? chkPinPrick.Checked : Convert.ToBoolean(node.SelectSingleNode("UEsen").InnerText); TextBox9.Text = node.SelectSingleNode("UEC5Left").InnerText; txtUEC5Right.Text = node.SelectSingleNode("UEC5Right").InnerText; TextBox11.Text = node.SelectSingleNode("UEC6Left").InnerText; TextBox12.Text = node.SelectSingleNode("UEC6Right").InnerText; TextBox13.Text = node.SelectSingleNode("UEC7Left").InnerText; TextBox14.Text = node.SelectSingleNode("UEC7Right").InnerText; TextBox15.Text = node.SelectSingleNode("UEC8Left").InnerText; TextBox16.Text = node.SelectSingleNode("UEC8Right").InnerText; TextBox18.Text = node.SelectSingleNode("UET1Right").InnerText; TextBox17.Text = node.SelectSingleNode("UET1Left").InnerText; TextBox20.Text = node.SelectSingleNode("UECervicalParaspinalsRight").InnerText; TextBox19.Text = node.SelectSingleNode("UECervicalParaspinalsLeft").InnerText; //cboHoffmanexam.SelectedValue = node.SelectSingleNode("HoffmanExam").InnerText; //chkStocking.Checked = node.SelectSingleNode("Stocking") == null ? chkStocking.Checked : Convert.ToBoolean(node.SelectSingleNode("Stocking").InnerText); //chkGlove.Checked = node.SelectSingleNode("Glove") == null ? chkGlove.Checked : Convert.ToBoolean(node.SelectSingleNode("Glove").InnerText); LEmmst.Checked = node.SelectSingleNode("LEmmst") == null ? LEmmst.Checked : Convert.ToBoolean(node.SelectSingleNode("LEmmst").InnerText); TextBox23.Text = node.SelectSingleNode("LEHipFlexionRight").InnerText; TextBox22.Text = node.SelectSingleNode("LEHipFlexionLeft").InnerText; TextBox41.Text = node.SelectSingleNode("LEHipAbductionRight").InnerText; TextBox40.Text = node.SelectSingleNode("LEHipAbductionLeft").InnerText; TextBox27.Text = node.SelectSingleNode("LEKneeExtensionRight").InnerText; TextBox26.Text = node.SelectSingleNode("LEKneeExtensionLeft").InnerText; TextBox43.Text = node.SelectSingleNode("LEKneeFlexionRight").InnerText; TextBox42.Text = node.SelectSingleNode("LEKneeFlexionLeft").InnerText; TextBox29.Text = node.SelectSingleNode("LEAnkleDorsiRight").InnerText; TextBox28.Text = node.SelectSingleNode("LEAnkleDorsiLeft").InnerText; TextBox45.Text = node.SelectSingleNode("LEAnklePlantarRight").InnerText; TextBox44.Text = node.SelectSingleNode("LEAnklePlantarLeft").InnerText; TextBox47.Text = node.SelectSingleNode("LEAnkleExtensorRight").InnerText; TextBox46.Text = node.SelectSingleNode("LEAnkleExtensorLeft").InnerText; UEmmst.Checked = node.SelectSingleNode("UEmmst") == null ? UEmmst.Checked : Convert.ToBoolean(node.SelectSingleNode("UEmmst").InnerText); TextBox31.Text = node.SelectSingleNode("UEShoulderAbductionRight").InnerText; TextBox30.Text = node.SelectSingleNode("UEShoulderAbductionLeft").InnerText; TextBox49.Text = node.SelectSingleNode("UEShoulderFlexionRight").InnerText; TextBox48.Text = node.SelectSingleNode("UEShoulderFlexionLeft").InnerText; TextBox33.Text = node.SelectSingleNode("UEElbowExtensionRight").InnerText; TextBox32.Text = node.SelectSingleNode("UEElbowExtensionLeft").InnerText; TextBox51.Text = node.SelectSingleNode("UEElbowFlexionRight").InnerText; TextBox50.Text = node.SelectSingleNode("UEElbowFlexionLeft").InnerText; TextBox53.Text = node.SelectSingleNode("UEElbowSupinationRight").InnerText; TextBox52.Text = node.SelectSingleNode("UEElbowSupinationLeft").InnerText; TextBox55.Text = node.SelectSingleNode("UEElbowPronationRight").InnerText; TextBox54.Text = node.SelectSingleNode("UEElbowPronationLeft").InnerText; TextBox37.Text = node.SelectSingleNode("UEWristFlexionRight").InnerText; TextBox36.Text = node.SelectSingleNode("UEWristFlexionLeft").InnerText; TextBox57.Text = node.SelectSingleNode("UEWristExtensionRight").InnerText; TextBox56.Text = node.SelectSingleNode("UEWristExtensionLeft").InnerText; TextBox39.Text = node.SelectSingleNode("UEHandGripStrengthRight").InnerText; TextBox38.Text = node.SelectSingleNode("UEHandGripStrengthLeft").InnerText; TextBox59.Text = node.SelectSingleNode("UEHandFingerAbductorsRight").InnerText; TextBox58.Text = node.SelectSingleNode("UEHandFingerAbductorsLeft").InnerText; } }
private DataGridColumn GetDataGridColumn(GridItem gItem) { Binding bding = new Binding(); if (!string.IsNullOrEmpty(gItem.PropertyName)) { bding.Mode = BindingMode.TwoWay; bding.Path = new PropertyPath(gItem.PropertyName); if (gItem.ReferenceDataInfo != null) { IValueConverter converter = CommonFunction.GetIValueConverter(gItem.ReferenceDataInfo.Type); bding.Converter = converter; } else if (gItem.PropertyName.Contains("MONEY")) { IValueConverter converter = new CurrencyConverter(); bding.Converter = converter; } else { IValueConverter converter = new CommonConvert(gItem); bding.Converter = converter; } } else { System.Diagnostics.Debug.WriteLine(""); } DataGridColumn dgc = null; switch (gItem.CType) { case ControlType.CheckBox : DataGridCheckBoxColumn dgcc = new DataGridCheckBoxColumn(); dgcc.IsThreeState = false; dgcc.Binding = bding; dgc = dgcc; break; case ControlType.Label : if (gItem.ReferenceDataInfo != null) { DataGridReferenceColumn dgrc = new DataGridReferenceColumn(); dgrc.Binding = bding; dgrc.DisplayMemberPath = "Text"; dgc = dgrc; } else { DataGridTextColumn dgtc = new MyDataGridTextColumn(gItem); dgtc.Binding = bding; dgc = dgtc; } break; case ControlType.Combobox : DataGridComboBoxColumn dgcbc = new DataGridComboBoxColumn(); if (gItem.ReferenceDataInfo != null) { IList<ITextValueItem> list = DataCore.GetRefData(gItem.ReferenceDataInfo.Type); dgcbc.ItemsSource = list; } dgcbc.DisplayMemberPath = "Text"; dgcbc.Binding = bding; dgc = dgcbc; break; case ControlType.TreeViewItem : DataGridIconColumn dgtvic = new DataGridIconColumn(); dgtvic.Binding = bding; dgc = dgtvic; break; case ControlType.Templete: //"<StackPanel Orientation="Horizontal"><smtx:ImageButton x:Name="myDelete" Click="Delete_Click"/></StackPanel>" var gridXCs = new XElementString("StackPanel",new XAttributeString("Orientation", "Horizontal")); DataGridTemplateColumn dtc = new DataGridTemplateColumn(); dtc.CellTemplate = DataTemplateHelper.GetDataTemplate(gridXCs); dgc = dtc; break; } return dgc; }
public void ShouldConvertForNumberLongWithDot() { var y = CommonConvert.ConvertStringToPrice("123.456.789"); Assert.AreEqual(123456789, y); }
//保存数据 public override string SaveData() { if (string.IsNullOrEmpty(_stockIn.SIType)) { _stockIn.SIType = "22";//调拨入库单 } if (string.IsNullOrEmpty(_stockIn.FromType)) { _stockIn.FromType = CommonConvert.GetFromTypeCode("源于Excel导入的入库单"); } _stockIn.SIStatus = 1; //已保存 _stockIn.FromBillType = "22"; //21采购入库单、22调拨入库单、23其他入库单 _stockIn.EditStatus = 0; //无人编辑 StringBuilder sb = new StringBuilder(); using (var edm = new Gold.DAL.GoldEntities()) { try { var tmp = edm.StockIn.SingleOrDefault(o => o.SICode == _stockIn.SICode); if (tmp == null) { edm.StockIn.AddObject(_stockIn); } else { if (tmp.SIStatus == 2) { throw new Exception("此入库单(" + tmp.SICode + ")已提交,不允许再次上传!"); } else if (tmp.SIStatus == 5) { throw new Exception("此入库单(" + tmp.SICode + ")正在撤销中,不允许再次上传!"); } else if (tmp.SIStatus == 3) { throw new Exception("此入库单(" + tmp.SICode + ")入库已完成,不允许再次上传!"); } else if (tmp.SIStatus == 4)//已撤销,则默认是全部撤销,用户可重新上传而不是覆盖 { //_stockIn.SICode = KeyGenerator.Instance.GetStockInKey(); //foreach (StockDetail sd in _stockIn.StockDetail) //{ // sd.BillCode = _stockIn.SICode; // sd.SOCode = _stockIn.SICode; //} //edm.StockIn.AddObject(_stockIn); throw new Exception("此入库单(" + tmp.SICode + ")已完成撤销,不允许再次上传!"); } else { List <StockDetail> lstDetail = new List <StockDetail>(); foreach (StockDetail oldDetail in tmp.StockDetail) { lstDetail.Add(oldDetail); //如果实收数量为0,则直接删除 if (oldDetail.NumActual == 0) { continue; } else { bool isExist = false;//是否新旧订单都有此商品 foreach (StockDetail newDetail in _stockIn.StockDetail) { //判断在当前的新excel中是否有此商品,如果有,则保存实收数量 if (newDetail.CargoCode == oldDetail.CargoCode) { newDetail.NumActual = oldDetail.NumActual; isExist = true; break; } } if (isExist) { continue; } else { //如果当前新excel没有此商品,则直接添加 StockDetail sd = new StockDetail(); sd.BillCode = oldDetail.BillCode; sd.BillRowNumber = oldDetail.BillRowNumber; sd.BillType = oldDetail.BillType; sd.BinCode = oldDetail.BinCode; sd.BinName = oldDetail.BinName; sd.CargoCode = oldDetail.CargoCode; sd.CargoModel = oldDetail.CargoModel; sd.CargoName = oldDetail.CargoName; sd.CargoSpec = oldDetail.CargoSpec; sd.CargoStatus = oldDetail.CargoStatus; sd.CargoUnits = oldDetail.CargoUnits; sd.Comment = oldDetail.Comment; sd.HandSetFinishTime = oldDetail.HandSetFinishTime; sd.HandSetPersonID = oldDetail.HandSetPersonID; sd.HandSetPersonName = oldDetail.HandSetPersonName; sd.InOutWHCode = oldDetail.InOutWHCode; sd.InOutWHName = oldDetail.InOutWHName; sd.NumActual = oldDetail.NumActual; sd.NumCurrentPlan = oldDetail.NumCurrentPlan; sd.NumOriginalPlan = oldDetail.NumOriginalPlan; sd.ReleaseYear = oldDetail.ReleaseYear; sd.Reserve1 = oldDetail.Reserve1; sd.Reserve2 = oldDetail.Reserve2; sd.RFIDOrderNo = oldDetail.RFIDOrderNo; sd.RFIDSubmitTime = oldDetail.RFIDSubmitTime; sd.RowTotalMoney = oldDetail.RowTotalMoney; sd.SICode = oldDetail.SICode; sd.UCOrderNo = oldDetail.UCOrderNo; _stockIn.StockDetail.Add(sd); } } } //由于遍历原数据行项目,导致后续删除无法级联删除。故先删除行项目。 foreach (StockDetail detail in lstDetail) { edm.StockDetail.DeleteObject(detail); edm.SaveChanges(); } edm.StockIn.DeleteObject(tmp); edm.SaveChanges(); edm.StockIn.AddObject(_stockIn); } } edm.SaveChanges(); sb.AppendLine("保存成功!"); } catch (Exception ex) { sb.Append("保存数据时发生异常:"); string msg = Utility.LogHelper.GetExceptionMsg(ex); sb.Append(msg); Utility.LogHelper.WriteLog(Utility.LogHelper.LogLevel.Error, "调拨入库单保存异常", ex); } } return(sb.ToString()); }
public void ShouldConvertForNumberLongWitComma() { var y = CommonConvert.ConvertStringToPrice("123,455,789"); Assert.AreEqual(123455789, y); }
public void CheckPriceParseOfERotenCom() { var x = CommonConvert.ConvertStringToPrice("657.00"); Assert.AreEqual(657, x); }
protected override void BindingOrderItem(object[] array) { if (_order.StockDetail == null) { _order.StockDetail = new EntityCollection <StockDetail>(); } if (_itemDefine == null) { throw new ApplicationException("未发现行项目字段定义!"); } if (_itemDefine.Count() == array.Count()) { StockDetail orderItem = new StockDetail(); for (int i = 0; i < array.Count(); i++) { string fieldName = Regex.Replace(_itemDefine[i].ToString(), @"\s", ""); string fieldValue = Regex.Replace(array[i].ToString(), @"\s", ""); switch (fieldName) { case "存货编码": orderItem.CargoCode = fieldValue; string cargoCode = DbCommonMethod.ParsingCargoCode(fieldValue); if (string.IsNullOrEmpty(cargoCode)) { throw new ApplicationException("商品不存在:" + fieldValue); } break; case "商品名称": orderItem.CargoName = fieldValue; break; case "规格": orderItem.CargoSpec = fieldValue; break; case "型号": //过滤型号值,如果型号是90.000,则去90,去掉小数点后面的0 double dou; string strModel = fieldValue; double douModel = 0; if (double.TryParse(fieldValue, out dou)) { douModel = dou; } if (douModel != 0 && strModel.Contains(".")) { string sdecimal = strModel.Substring(strModel.IndexOf(".") + 1, strModel.Length - strModel.IndexOf(".") - 1); int istring = Convert.ToInt32(sdecimal); if (istring == 0) { strModel = fieldValue.Substring(0, fieldValue.IndexOf(".")); } } orderItem.CargoModel = strModel; break; case "单位": orderItem.CargoUnits = fieldValue; break; case "数量": if (!string.IsNullOrEmpty(fieldValue)) { double d; if (double.TryParse(fieldValue, out d)) { orderItem.NumOriginalPlan = d; } } break; //暂留空,因为没看到有字段保存单价信息的(因为系统只管商品,不管金额,所以暂时不用存单价) //case "销售单价": // if (!string.IsNullOrEmpty(fieldValue)) // { // decimal d; // if (decimal.TryParse(fieldValue, out d)) // orderItem.Price = d; // } // break; case "销售金额": if (!string.IsNullOrEmpty(fieldValue)) { decimal de; if (decimal.TryParse(fieldValue, out de)) { orderItem.RowTotalMoney = de; } } break; default: break; } } if (string.IsNullOrEmpty(orderItem.BillRowNumber)) { orderItem.BillRowNumber = _rowNum.ToString(); } orderItem.NumCurrentPlan = orderItem.NumOriginalPlan; //订单数量=应收数量,默认值 orderItem.CargoStatus = 0; //手持机未完成 orderItem.BillCode = _order.SOCode; orderItem.SOCode = _order.SOCode; orderItem.BillType = CommonConvert.GetBillTypeCode("出库单"); orderItem.InOutWHCode = _order.WHCode; orderItem.StockOut = _order; IEnumerable <KeyValuePair <string, object> > entityKeyValues = new KeyValuePair <string, object>[] { new KeyValuePair <string, object>("BillCode", orderItem.BillCode), new KeyValuePair <string, object>("BillRowNumber", orderItem.BillRowNumber) }; orderItem.EntityKey = new EntityKey("GoldEntities.StockDetail", entityKeyValues); _order.StockDetail.Add(orderItem); } }
/// <summary> /// 从DataTable中获取采购订单明细实体列表 /// </summary> /// <param name="dt"></param> /// <param name="msg"></param> /// <returns></returns> private List <DAL.StockDetail> GetModelDetailFromDataTable(DataTable dt, out string msg, string SICode, string WHCode) { try { List <DAL.StockDetail> list = new List <DAL.StockDetail>(); msg = ""; //接口协议文档中定义的字段 Dictionary <string, string> dataFieldNameDic = new Dictionary <string, string>(); dataFieldNameDic.Add("BillCode", "其他入库单号"); dataFieldNameDic.Add("DetailRowNumber", "行号"); dataFieldNameDic.Add("CargoCode", "商品编码"); dataFieldNameDic.Add("CargoName", "商品名称"); dataFieldNameDic.Add("CargoSpec", "规格"); dataFieldNameDic.Add("CargoModel", "型号"); dataFieldNameDic.Add("CargoUnits", "单位"); dataFieldNameDic.Add("NumOriginalPlan", "数量"); dataFieldNameDic.Add("Remark", "备注"); if (dt == null || dt.Rows.Count == 0) { msg = "用友系统返回数据集中无数据!"; return(new List <StockDetail>()); } StringBuilder errorColName = new StringBuilder(); //检查数据集中是否存在指定字段 foreach (KeyValuePair <string, string> kvp in dataFieldNameDic) { if (dt.Columns.Contains(kvp.Key) == false) { errorColName.Append(Environment.NewLine); errorColName.Append(kvp.Value); errorColName.Append("-"); errorColName.Append(kvp.Key); } } if (errorColName.Length > 0) { errorColName.Insert(0, "用友系统返回的数据集中未包含如下字段,不能进行有效解析!"); msg = errorColName.ToString(); return(new List <StockDetail>());; } //遍历数据集创建实体 foreach (DataRow dr in dt.Rows) { StockDetail newModel = new StockDetail(); //newModel.BillCode= DataCheckHelper.GetCellString(dr["BillCode"]); newModel.BillRowNumber = DataCheckHelper.GetCellString(dr["DetailRowNumber"]); //商品编码 newModel.CargoCode = DataCheckHelper.GetCellString(dr["CargoCode"]); string cargoCode = DbCommonMethod.ParsingCargoCode(newModel.CargoCode); if (string.IsNullOrEmpty(cargoCode)) { throw new ApplicationException("单号" + DataCheckHelper.GetCellString(dr["BillCode"]) + ",商品不存在:" + newModel.CargoCode); } newModel.CargoName = DataCheckHelper.GetCellString(dr["CargoName"]); newModel.CargoSpec = DataCheckHelper.GetCellString(dr["CargoSpec"]); newModel.CargoModel = DataCheckHelper.GetCellString(dr["CargoModel"]); newModel.CargoUnits = DataCheckHelper.GetCellString(dr["CargoUnits"]); //数量 if (!string.IsNullOrEmpty(DataCheckHelper.GetCellString(dr["NumOriginalPlan"]))) { double d; if (double.TryParse(DataCheckHelper.GetCellString(dr["NumOriginalPlan"]), out d)) { newModel.NumOriginalPlan = d; } } newModel.Comment = DataCheckHelper.GetCellString(dr["Remark"]); newModel.NumCurrentPlan = newModel.NumOriginalPlan; //订单数量=应收数量,默认值 newModel.CargoStatus = 0; //手持机未完成 newModel.SICode = SICode; newModel.BillCode = newModel.SICode; newModel.BillType = CommonConvert.GetBillTypeCode("入库单"); newModel.InOutWHCode = WHCode; string bill = DataCheckHelper.GetCellString(dr["BillCode"]); List <StockDetail> existStockDetail = (from r in list where r.BillCode == bill && r.BillRowNumber == newModel.BillRowNumber select r).ToList <StockDetail>(); if (existStockDetail == null || existStockDetail.Count == 0)//过滤重复数据 { list.Add(newModel); } } return(list); } catch (Exception ex) { msg = ex.Message; return(new List <StockDetail>());; } }
/// <summary> /// 从DataTable中获取实体列表 /// </summary> /// <param name="dt"></param> /// <param name="msg"></param> /// <returns></returns> private List <DAL.StockIn> GetModelFromDataTable(DataTable dt, out string msg) { try { List <DAL.StockIn> list = new List <DAL.StockIn>(); msg = ""; //接口协议文档中定义的字段 Dictionary <string, string> dataFieldNameDic = new Dictionary <string, string>(); dataFieldNameDic.Add("BillCode", "其他入库单号"); dataFieldNameDic.Add("BillDate", "日期"); dataFieldNameDic.Add("InCategory", "收发类别"); dataFieldNameDic.Add("Supplier", "供货单位"); dataFieldNameDic.Add("BusinessDepartmentName", "业务部门"); dataFieldNameDic.Add("Operator", "业务员姓名"); dataFieldNameDic.Add("WHName", "仓库名称"); dataFieldNameDic.Add("StoreKeeper", "库管员"); dataFieldNameDic.Add("Comment", "备注"); dataFieldNameDic.Add("TotalNumber", "合计数量"); dataFieldNameDic.Add("WareHouseKeeper", "仓管"); dataFieldNameDic.Add("Checker", "验收"); if (dt == null || dt.Rows.Count == 0) { msg = "用友系统返回数据集中无数据!"; return(new List <StockIn>()); } StringBuilder errorColName = new StringBuilder(); //检查数据集中是否存在指定字段 foreach (KeyValuePair <string, string> kvp in dataFieldNameDic) { if (dt.Columns.Contains(kvp.Key) == false) { errorColName.Append(Environment.NewLine); errorColName.Append(kvp.Value); errorColName.Append("-"); errorColName.Append(kvp.Key); } } if (errorColName.Length > 0) { errorColName.Insert(0, "用友系统返回的数据集中未包含如下字段,不能进行有效解析!"); msg = errorColName.ToString(); return(new List <StockIn>());; } //遍历数据集创建实体 foreach (DataRow dr in dt.Rows) { StockIn newModel = new StockIn(); //newModel.SICode = KeyGenerator.Instance.GetStockInKey(); newModel.FromBillNo = DataCheckHelper.GetCellString(dr["BillCode"]); //日期 if (!string.IsNullOrEmpty(DataCheckHelper.GetCellString(dr["BillDate"]))) { DateTime d; if (DateTime.TryParse(DataCheckHelper.GetCellString(dr["BillDate"]), out d)) { newModel.SIDate = d; } } //收发类别 newModel.InCategory = DbCommonMethod.GetInCategory(DataCheckHelper.GetCellString(dr["InCategory"])); newModel.Supplier = DataCheckHelper.GetCellString(dr["Supplier"]); newModel.BusinessDepartmentName = DataCheckHelper.GetCellString(dr["BusinessDepartmentName"]); newModel.Operator = DataCheckHelper.GetCellString(dr["Operator"]); //仓库 newModel.WHName = DataCheckHelper.GetCellString(dr["WHName"]); newModel.WHCode = DbCommonMethod.ParsingWarehouse(newModel.WHName); if (string.IsNullOrEmpty(newModel.WHCode)) { throw new ApplicationException("单号" + newModel.FromBillNo + ",仓库不存在:" + newModel.WHName); } newModel.StoreKeeper = DataCheckHelper.GetCellString(dr["StoreKeeper"]); newModel.Comment = DataCheckHelper.GetCellString(dr["Comment"]); //合计数量 if (!string.IsNullOrEmpty(DataCheckHelper.GetCellString(dr["TotalNumber"]))) { double d; if (double.TryParse(DataCheckHelper.GetCellString(dr["TotalNumber"]), out d)) { newModel.TotalNumber = d; } } //newModel = DataCheckHelper.GetCellString(dr["WareHouseKeeper"]); newModel.Checker = DataCheckHelper.GetCellString(dr["Checker"]); newModel.SIStatus = 1; //已保存 newModel.FromBillType = "23"; //21采购入库单、22调拨入库单、23其他入库单 newModel.SIType = CommonConvert.GetSIOTypeCode("其他入库单"); newModel.FromType = CommonConvert.GetFromTypeCode("源于Excel导入的入库单"); List <StockIn> existStockIn = (from r in list where r.FromBillNo == newModel.FromBillNo select r).ToList <StockIn>(); if (existStockIn == null || existStockIn.Count == 0)//过滤重复数据 { list.Add(newModel); } } return(list); } catch (Exception ex) { msg = ex.Message; return(new List <StockIn>());; } }
/// <summary> /// 从DataTable中获取实体列表 /// </summary> /// <param name="dt"></param> /// <param name="msg"></param> /// <returns></returns> private List <DAL.StockOut> GetModelFromDataTable(DataTable dt, out string msg) { try { List <DAL.StockOut> list = new List <DAL.StockOut>(); msg = ""; //接口协议文档中定义的字段 Dictionary <string, string> dataFieldNameDic = new Dictionary <string, string>(); dataFieldNameDic.Add("BillCode", "其他出库单号"); dataFieldNameDic.Add("BillDate", "日期"); dataFieldNameDic.Add("OutCategory", "收发类别"); dataFieldNameDic.Add("OutWHName", "发出仓库"); dataFieldNameDic.Add("Comment", "备注"); dataFieldNameDic.Add("TotalNumber", "合计数量"); dataFieldNameDic.Add("LeaderSign", "领导"); dataFieldNameDic.Add("WareHouseKeeper", "仓管"); dataFieldNameDic.Add("AccountSign", "财务"); dataFieldNameDic.Add("BusinessSign", "经办人"); dataFieldNameDic.Add("EditorSign", "制单人"); if (dt == null || dt.Rows.Count == 0) { msg = "用友系统返回数据集中无数据!"; return(new List <StockOut>()); } StringBuilder errorColName = new StringBuilder(); //检查数据集中是否存在指定字段 foreach (KeyValuePair <string, string> kvp in dataFieldNameDic) { if (dt.Columns.Contains(kvp.Key) == false) { errorColName.Append(Environment.NewLine); errorColName.Append(kvp.Value); errorColName.Append("-"); errorColName.Append(kvp.Key); } } if (errorColName.Length > 0) { errorColName.Insert(0, "用友系统返回的数据集中未包含如下字段,不能进行有效解析!"); msg = errorColName.ToString(); return(new List <StockOut>());; } //遍历数据集创建实体 foreach (DataRow dr in dt.Rows) { StockOut newModel = new StockOut(); //newModel.SOCode = KeyGenerator.Instance.GetStockOutKey(); newModel.FromBillNo = DataCheckHelper.GetCellString(dr["BillCode"]); //日期 if (!string.IsNullOrEmpty(DataCheckHelper.GetCellString(dr["BillDate"]))) { DateTime d; if (DateTime.TryParse(DataCheckHelper.GetCellString(dr["BillDate"]), out d)) { newModel.SODate = d; } } //收发类别 newModel.OutCategory = DbCommonMethod.GetOutCategory(DataCheckHelper.GetCellString(dr["OutCategory"])); newModel.WHName = DataCheckHelper.GetCellString(dr["OutWHName"]); newModel.WHCode = DbCommonMethod.ParsingWarehouse(newModel.WHName); if (string.IsNullOrEmpty(newModel.WHCode)) { throw new ApplicationException("单号" + newModel.FromBillNo + ",仓库不存在:" + newModel.WHName); } newModel.Comment = DataCheckHelper.GetCellString(dr["Comment"]); //合计数量 if (!string.IsNullOrEmpty(DataCheckHelper.GetCellString(dr["TotalNumber"]))) { decimal d; if (decimal.TryParse(DataCheckHelper.GetCellString(dr["TotalNumber"]), out d)) { newModel.TotalMoney = d; } } newModel.LeaderSign = DataCheckHelper.GetCellString(dr["LeaderSign"]); newModel.WarehouseSign = DataCheckHelper.GetCellString(dr["WareHouseKeeper"]); newModel.AccountSign = DataCheckHelper.GetCellString(dr["AccountSign"]); newModel.BusinessSign = DataCheckHelper.GetCellString(dr["BusinessSign"]); newModel.EditorSign = DataCheckHelper.GetCellString(dr["EditorSign"]); newModel.SOStatus = 1; //已保存 newModel.FromBillType = "13"; //11-销售出库单、12-调拨出库单、13-其他出库单 newModel.EditStatus = 0; //无人编辑 newModel.SOType = CommonConvert.GetSIOTypeCode("其他出库单"); newModel.FromType = CommonConvert.GetFromTypeCode("源于Excel导入的出库单"); List <StockOut> existStockOut = (from r in list where r.FromBillNo == newModel.FromBillNo select r).ToList <StockOut>(); if (existStockOut == null || existStockOut.Count == 0)//过滤重复数据 { list.Add(newModel); } } return(list); } catch (Exception ex) { msg = ex.Message; return(new List <StockOut>());; } }
protected void btnupload_mul_Click(object sender, EventArgs e) { DBHelperClass dBHelperClass = new DBHelperClass(); DataSet dataSet = new DataSet(); string fname = "", lname = "", doa = ""; foreach (HttpPostedFile postedFile in fupmul.PostedFiles) { //string[] fileName = Path.GetFileName(postedFile.FileName).Split(','); string fileName = Path.GetFileName(postedFile.FileName); string msg = ""; try { Regex re = new Regex(@"\d+"); Match m = re.Match(fileName); if (m.Success) { string file = fileName.Substring(0, m.Index); string[] str = file.Split(','); // lblResults.Text = string.Format("RegEx found " + m.Value + " at position " + m.Index.ToString() + " character in string is " + file + " fname: " + str[1] + ",LastName:" + str[0]); lname = str[0]; if (str[1].Contains("_")) { fname = str[1].Split('_')[0]; } else { fname = str[1]; } file = fileName; str = file.Split('_'); if (str.Length > 2) { doa = str[str.Length - 1].ToLower().Split('.')[0]; } } else { string[] str = fileName.Split('_'); fname = str[0].Split(',')[1]; lname = str[0].Split(',')[0]; } doa = CommonConvert.DateformatDOA(doa); doa = CommonConvert.DateFormat(doa); string[] strfname = fname.TrimStart().Split(' '); fname = strfname[0]; dataSet = dBHelperClass.selectData("select Patient_ID from tblPatientMaster where LastName='" + lname.Trim().TrimStart() + "' and FirstName='" + fname.Trim().TrimStart() + "'"); if (dataSet != null && dataSet.Tables[0].Rows.Count > 0) { string patientid = dataSet.Tables[0].Rows[0][0].ToString(); string upload_folder_path = "~/PatientDocument/" + patientid; if (!Directory.Exists(upload_folder_path)) { Directory.CreateDirectory(Server.MapPath(upload_folder_path)); } postedFile.SaveAs(System.IO.Path.Combine(Server.MapPath(upload_folder_path), fileName)); sb.Append("<p>File Name : " + fileName + " patientid:" + patientid + " Status : Uploaded </p>"); sb.Append(Environment.NewLine); Logger.Info("File Name : " + fileName + " patientid:" + patientid + " Status : Uploaded"); //string filename = System.DateTime.Now.Millisecond.ToString() + "_" + fileName; if (checkName(fileName, patientid) == false) { string filename = fileName; string query = "insert into tblPatientDocument values('" + filename + "','" + System.DateTime.Now.ToString() + "','" + upload_folder_path + "/" + filename + "'," + patientid + ",'" + doa + "')"; dBHelperClass.executeQuery(query); } } else { sb.Append("<p style='color:red'> File Name : " + fileName + " Status : Not Uploaded</p>"); sb.Append(Environment.NewLine); Logger.Info("File Name : " + fileName + " Status : Not Uploaded"); } } catch (Exception ex) { sb.Append("<p style='color:red'>File Name : " + fileName + " Status : Not Uploaded </p>"); Logger.Error("File Name : " + fileName + " Status : Not Uploaded \n"); } lblResult.InnerHtml = sb.ToString(); } }
public void ShouldConvertForGreaterOneComanAndLessThreadNumbeEnd() { var y = CommonConvert.ConvertStringToPrice("123,789,91"); Assert.AreEqual(123789.91, y); }