public List<DicReader> GetPlistVisitingLogTrs(string key, DateTime? leftVisitOn, DateTime? rightVisitOn, PagingInput paging) { paging.Valid(); if (key != null) { key = key.Trim(); } Func<SqlFilter> filter = () => { var parameters = new List<DbParameter>(); var filterString = @" where a.LoginName like @key "; parameters.Add(CreateParameter("key", "%" + key + "%", DbType.String)); if (leftVisitOn.HasValue) { parameters.Add(CreateParameter("leftVisitOn", leftVisitOn.Value, DbType.DateTime)); filterString += " and a.VisitOn>=@leftVisitOn"; } if (rightVisitOn.HasValue) { parameters.Add(CreateParameter("rightVisitOn", rightVisitOn.Value, DbType.DateTime)); filterString += " and a.VisitOn<@rightVisitOn"; } return new SqlFilter(filterString, parameters.ToArray()); }; return base.GetPlist("VisitingLog", filter, paging); }
public Category[] GetAllCategories() { List<Category> myCategories = new List<Category>(); SqlConnection myConn = new SqlConnection(connstring); myConn.Open(); SqlCommand mySqlCommand = new SqlCommand("select * from Category", myConn); SqlDataReader reader = mySqlCommand.ExecuteReader(); while (reader.Read()) { Category myCategory = new Category(); object id = reader["Id"]; if (id != null) { int categoryId = -1; if (!int.TryParse(id.ToString(), out categoryId)) { throw new Exception("Failed to parse Id of video."); } myCategory.Id = categoryId; } myCategory.Name = reader["Name"].ToString(); myCategories.Add(myCategory); } myConn.Close(); return myCategories.ToArray(); }
static void InsertBatch() { Console.WriteLine("Inserting a bunch of trial data objects..."); var trialBatch = new List<Model.TrialData>(); var random = new Random(); var watch = new Stopwatch(); watch.Start(); for(int i=1; i<=50000; i++) { var parameters = new List<Parameter> {new Parameter { Name = "GBP.TotalReturnIndex", TrialNumber = 1, Value = random.NextDouble() }, new Parameter { Name = "USD.TotalReturnIndex", TrialNumber = 2, Value = random.NextDouble() }, new Parameter { Name = "EUR.TotalReturnIndex", TrialNumber = 3, Value = random.NextDouble() }}; var trialData = new TrialData { StressNumber = i, Parameters = parameters.ToArray() }; //var ravenConnection = new RavenConnection { ServerUrl = "http://localhost:8081/", DatabaseName = "TrialData" }; //Console.WriteLine("Inserting Stress {0}", i); //var ravenDB = new RavenDB(); //var elapsed = ravenDB.PostTrialData(ravenConnection, trialData); //Console.WriteLine("insert complete in {0}ms", elapsed); trialBatch.Add(trialData); } var ravenConnection = new Model.RavenConnection { ServerUrl = "http://localhost:8081/", DatabaseName = "TrialData" }; var ravenDB = new RavenDB(); var elapsed = ravenDB.BulkInsertTrialData(ravenConnection, trialBatch); watch.Stop(); //var elapsed = ravenDB.BulkInsertTrialDataEmbedded(ravenConnection, trialBatch); Console.WriteLine(); Console.WriteLine("Operation complete in {0} minutes, {1} seconds and {2} milliseconds", watch.Elapsed.Minutes, watch.Elapsed.Seconds, watch.Elapsed.Milliseconds); }
protected override void OnNavigatedTo(NavigationEventArgs e) { ScrollViewer.SetVerticalScrollMode(CategoryPageGridView, ScrollMode.Disabled); CategoryPageViewModel categoryPageViewModel = (CategoryPageViewModel)Resources["CategoryPageViewModel"]; NavigationItem navigationItem = e.Parameter as NavigationItem; var task = Task.Factory.StartNew(async () => { var bundle = await DownloadNavigationItem(navigationItem.ReferralId); var navigationItems = await DownloadNavigationItemsAsync(); await CoreApplication.MainView.CoreWindow.Dispatcher.RunAsync(CoreDispatcherPriority.High, () => { categoryPageViewModel.Content = bundle.Content[0]; var items = new List<Content>(bundle.Content); items.RemoveAt(0); bundle.Content = items.ToArray(); categoryPageViewModel.Bundle = bundle; categoryPageViewModel.NavigationItems = navigationItems; LoadingGrid.Visibility = Visibility.Collapsed; MySplitView.Visibility = Visibility.Visible; } ); }); base.OnNavigatedTo(e); }
public override object ReadJson(JsonReader reader, Type objectType, object existingValue, JsonSerializer serializer) { HaParams returnValue = null; var deserializationErrorMessage = "Could not read ha-params value"; if (reader.TokenType == JsonToken.Integer) { returnValue = new HaParams {AssociatedHaMode = HaMode.Exactly, ExactlyCount = (long)reader.Value}; }else if (reader.TokenType == JsonToken.StartArray) { var potentialReturnValue = new HaParams {AssociatedHaMode = HaMode.Nodes}; var nodesList = new List<string>(); do { reader.Read(); if (!new[] {JsonToken.EndArray, JsonToken.String}.Contains(reader.TokenType)) { deserializationErrorMessage = "Could not read ha-params array value"; } else if(reader.TokenType == JsonToken.String) { nodesList.Add(reader.Value as string); } } while (reader.TokenType == JsonToken.String); potentialReturnValue.Nodes = nodesList.ToArray(); returnValue = potentialReturnValue; } if (returnValue != null) { return returnValue; } throw new JsonSerializationException(deserializationErrorMessage); }
public List<DicReader> GetPlistCatalogAccountTrs(string key, string catalogCode , bool includeDescendants, PagingInput paging) { paging.Valid(); if (string.IsNullOrEmpty(catalogCode)) { throw new ArgumentNullException("catalogCode"); } Func<SqlFilter> filter = () => { var parameters = new List<DbParameter>(); var filterString = " where (a.Name like @key or a.Code like @key or a.LoginName like @key)"; parameters.Add(CreateParameter("key", "%" + key + "%", DbType.String)); if (!includeDescendants) { parameters.Add(CreateParameter("CatalogCode", catalogCode, DbType.String)); filterString += " and a.CatalogCode=@CatalogCode"; } else { parameters.Add(CreateParameter("CatalogCode", catalogCode + "%", DbType.String)); filterString += " and a.CatalogCode like @CatalogCode"; } return new SqlFilter(filterString, parameters.ToArray()); }; return base.GetPlist("CatalogAccountTr", filter, paging); }
public List<DicReader> GetPlistGroupAccountTrs(string key, Guid groupId, PagingInput paging) { paging.Valid(); Func<SqlFilter> filter = () => { var parameters = new List<DbParameter>(); const string filterString = @" where (a.Name like @key or a.Code like @key or a.LoginName like @key) and a.GroupId=@GroupId"; parameters.Add(CreateParameter("key", "%" + key + "%", DbType.String)); parameters.Add(CreateParameter("GroupId", groupId, DbType.Guid)); return new SqlFilter(filterString, parameters.ToArray()); }; return base.GetPlist("GroupAccountTr", filter, paging); }
public List<DicReader> GetPlistVisitingLogTrs(Guid accountId, string loginName, DateTime? leftVisitOn, DateTime? rightVisitOn, PagingInput paging) { paging.Valid(); loginName = (loginName ?? string.Empty).ToLower(); Func<SqlFilter> filter = () => { var parameters = new List<DbParameter>(); var filterString = @" where (a.AccountId=@AccountId or Lower(a.LoginName)=@LoginName) "; parameters.Add(CreateParameter("LoginName", loginName, DbType.String)); parameters.Add(CreateParameter("AccountId", accountId, DbType.Guid)); if (leftVisitOn.HasValue) { parameters.Add(CreateParameter("leftVisitOn", leftVisitOn.Value, DbType.DateTime)); filterString += " and a.VisitOn>=@leftVisitOn"; } if (rightVisitOn.HasValue) { parameters.Add(CreateParameter("rightVisitOn", rightVisitOn.Value, DbType.DateTime)); filterString += " and a.VisitOn<@rightVisitOn"; } return new SqlFilter(filterString, parameters.ToArray()); }; return base.GetPlist("VisitingLog", filter, paging); }
void UCOldPartsPalautusManager_DeleteEvent(object sender, EventArgs e) { try { List<string> listField = new List<string>(); foreach (DataGridViewRow dr in dgvRData.Rows) { object isCheck = dr.Cells["colCheck"].EditedFormattedValue; if (isCheck != null && (bool)isCheck) { listField.Add(dr.Cells["return_id"].Value.ToString()); } } if (listField.Count == 0) { MessageBoxEx.Show("请选择删除记录!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (MessageBoxEx.Show("确认要删除吗?", "提示", MessageBoxButtons.OKCancel) != DialogResult.OK) { return; } Dictionary<string, string> comField = new Dictionary<string, string>(); comField.Add("enable_flag", Convert.ToInt32(DataSources.EnumEnableFlag.DELETED).ToString()); comField.Add("update_by", HXCPcClient.GlobalStaticObj.UserID);//修改人Id comField.Add("update_name", HXCPcClient.GlobalStaticObj.UserName);//修改人姓名 comField.Add("update_time", Common.LocalDateTimeToUtcLong(HXCPcClient.GlobalStaticObj.CurrentDateTime).ToString());//修改时间 bool flag = DBHelper.BatchUpdateDataByIn("批量删除宇通旧件返厂单", "tb_maintain_oldpart_recycle", comField, "return_id", listField.ToArray()); if (flag) { BindPageData(); if (dgvRData.Rows.Count > 0) { dgvRData.CurrentCell = dgvRData.Rows[0].Cells[0]; } MessageBoxEx.Show("删除成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBoxEx.Show("删除失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception ex) { MessageBoxEx.Show("删除失败!" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public List<dr_pre_visit> SearchPreVisitList(int drid, int visit_id, int patient_id, DateTime? pre_date1, DateTime? pre_date2, string pre_time, int pre_type, DateTime? createtime1, DateTime? createtime2, int status , DateTime? visit_date1, DateTime? visit_date2, orderbyEnum? orderby, string orderbyCol, int pageIndex, int pageSize, out string error) { error = string.Empty; try { #region Command string selectSql = string.Format("select *,COALESCE(info.name,'') as patient_name,info.gender as gender from dr_pre_visit pre left join dr_visit on pre.visit_id=dr_visit.pkid left join patient_info info on pre.patient_id=info.pkid WHERE TRUE "); StringBuilder conditionSb = new System.Text.StringBuilder(); List<MySqlParameter> paraList = new List<MySqlParameter>(); #endregion #region 搜索条件 if (drid > 0) { conditionSb.Append(" AND dr_visit.drid = @drid "); paraList.Add(new MySqlParameter("drid", drid)); } if (visit_id > 0) { conditionSb.Append(" AND pre.visit_id = @visit_id "); paraList.Add(new MySqlParameter("visit_id", visit_id)); } if (patient_id > 0) { conditionSb.Append(" AND pre.patient_id = @patient_id "); paraList.Add(new MySqlParameter("patient_id", patient_id)); } if (pre_date1.HasValue) { conditionSb.Append(" AND DATEDIFF(pre.pre_date,@pre_date1) >= 0 "); paraList.Add(new MySqlParameter("pre_date1", pre_date1.Value)); } if (pre_date2.HasValue) { conditionSb.Append(" AND DATEDIFF(pre.pre_date,@pre_date2) <= 0 "); paraList.Add(new MySqlParameter("pre_date2", pre_date2.Value)); } if (!string.IsNullOrEmpty(pre_time)) { conditionSb.Append(" AND pre.pre_time = @pre_time "); paraList.Add(new MySqlParameter("pre_time", pre_time)); } if (pre_type > 0) { conditionSb.Append(" AND pre.pre_type = @pre_type "); paraList.Add(new MySqlParameter("pre_type", pre_type)); } if (visit_date1.HasValue) { conditionSb.Append(" AND DATEDIFF(pre.createtime,@createtime1) >= 0 "); paraList.Add(new MySqlParameter("createtime1", createtime1.Value)); } if (createtime2.HasValue) { conditionSb.Append(" AND DATEDIFF(pre.createtime,@createtime2) <= 0 "); paraList.Add(new MySqlParameter("createtime2", createtime2.Value)); } if (status > 0) { conditionSb.Append(" AND dr_visit.status = @status "); paraList.Add(new MySqlParameter("status", status)); } if (visit_date1.HasValue) { conditionSb.Append(" AND DATEDIFF(dr_visit.visit_date,@visit_date1) >= 0 "); paraList.Add(new MySqlParameter("visit_date1", visit_date1.Value)); } if (visit_date2.HasValue) { conditionSb.Append(" AND DATEDIFF(dr_visit.visit_date,@visit_date2) <= 0 "); paraList.Add(new MySqlParameter("visit_date2", visit_date2.Value)); } #endregion #region 排序 分页 string orderbyStr = string.Empty; if (!string.IsNullOrEmpty(orderbyCol) && orderby.HasValue) orderbyStr = orderbyFormat.getSortStr(orderby.Value, orderbyCol); else orderbyStr = " order by pre.pkid "; selectSql += conditionSb.ToString() + orderbyStr; if (pageIndex > 0) { selectSql += " LIMIT @pageIndex , @pageSize "; paraList.Add(new MySqlParameter("pageIndex", (pageIndex - 1) * pageSize)); paraList.Add(new MySqlParameter("pageSize", pageSize)); } #endregion #region 执行 var resultList = db.Database.SqlQuery<dr_pre_visit>(selectSql, paraList.ToArray()).ToList(); return resultList; #endregion } catch (Exception ex) { error += BaseTool.FormatExceptionMessage(ex); return null; } }
/// <summary> /// 删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void UCPersonnelManager_DeleteEvent(object sender, EventArgs e) { List<string> listField = new List<string>(); List<DataGridViewRow> deleteUser = new List<DataGridViewRow>(); foreach (DataGridViewRow dr in dgvUser.Rows) { object isCheck = dr.Cells["colCheck"].EditedFormattedValue; if (isCheck != null && (bool)isCheck) { listField.Add(dr.Cells["user_id"].Value.ToString()); deleteUser.Add(dr); } } if (listField.Count == 0) { MessageBoxEx.Show("请选择删除记录!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (MessageBoxEx.ShowQuestion("是否确认删除?")) { Dictionary<string, string> comField = new Dictionary<string, string>(); comField.Add("enable_flag", "0"); bool flag = DBHelper.BatchUpdateDataByIn("批量删除人员", "sys_user", comField, "user_id", listField.ToArray()); if (flag) { UploadUserData(listField); BindPageData(); if (dgvUser.Rows.Count > 0) { dgvUser.CurrentCell = dgvUser.Rows[0].Cells[0]; } MessageBoxEx.Show("删除成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); LocalCache._Update(CacheList.User); } else { MessageBoxEx.Show("删除失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } }
protected override TestGroup[] SelectGroups(TestNode testNode) { List<TestGroup> groups = new List<TestGroup>(); foreach (XmlNode node in testNode.Xml.SelectNodes("properties/property[@name='Category']")) { var groupName = node.Attributes["value"].Value; var group = Groups.Find((g) => g.Name == groupName);//GetGroup(groupName); if (group == null) { group = new TestGroup(groupName); Groups.Add(group); groups.Add(group); } } if (groups.Count == 0) groups.Add(Groups[0]); return groups.ToArray(); }
/// <summary> SQLBulk方式操作带事务无操作备份 /// </summary> /// <param name="connStr">数据库连接串</param> /// <param name="tableName">表名</param> /// <param name="listRow">DataRowList集合</param> /// <returns>SQLBulk批处理方式操作带事务,执行结果。全部成功,返回Bool True; 否则,返回False。</returns> public static bool SqlBulkByTransNoLogNoBackUp(string connStr, string tableName, List<DataRow> listRow) { if (listRow.Count == 0) { return true; } using (SqlConnection conn = new SqlConnection(connStr)) { conn.Open(); SqlTransaction tran = conn.BeginTransaction(); using (SqlBulkCopy bulkCopy = new SqlBulkCopy(conn, SqlBulkCopyOptions.CheckConstraints, tran)) { bulkCopy.DestinationTableName = tableName; bulkCopy.BulkCopyTimeout = 300; DataTable dt = listRow[0].Table; foreach (DataColumn dc in dt.Columns) { bulkCopy.ColumnMappings.Add(dc.ColumnName, dc.ColumnName); } try { bulkCopy.WriteToServer(listRow.ToArray()); tran.Commit(); return true; } catch (Exception ex) { tran.Rollback(); throw ex; } finally { bulkCopy.Close(); tran.Dispose(); } } } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Wgw_listEntity model) { StringBuilder strSql = new StringBuilder(); List<SqlParameter> parameters = new List<SqlParameter>(); strSql.Append("update Wgw_list set "); if (!string.IsNullOrEmpty(model.typeone)) { strSql.Append(" typeone = @typeone , "); parameters.Add(new SqlParameter("@typeone", model.typeone)); } if (!string.IsNullOrEmpty(model.typetwo)) { strSql.Append(" typetwo = @typetwo , "); parameters.Add(new SqlParameter("@typetwo", model.typetwo)); } if (true) { strSql.Append(" pid = @pid , "); parameters.Add(new SqlParameter("@pid", model.pid)); } if (true) { strSql.Append(" clientid = @clientid , "); parameters.Add(new SqlParameter("@clientid", model.clientid)); } if (!string.IsNullOrEmpty(model.listname)) { strSql.Append(" listname = @listname , "); parameters.Add(new SqlParameter("@listname", model.listname)); } if (!string.IsNullOrEmpty(model.listdesc)) { strSql.Append(" listdesc = @listdesc , "); parameters.Add(new SqlParameter("@listdesc", model.listdesc)); } if (true) { strSql.Append(" listorder = @listorder , "); parameters.Add(new SqlParameter("@listorder", model.listorder)); } if (!string.IsNullOrEmpty(model.listcover)) { strSql.Append(" listcover = @listcover , "); parameters.Add(new SqlParameter("@listcover", model.listcover)); } strSql.Append(" isshow = @isshow , "); parameters.Add(new SqlParameter("@isshow", model.isshow)); if (!string.IsNullOrEmpty(model.icon)) { strSql.Append(" icon = @icon , "); parameters.Add(new SqlParameter("@icon", model.icon)); } strSql = strSql.Remove(strSql.Length - 2, 2); strSql.Append(" where id=@id "); parameters.Add(new SqlParameter("@id", model.id)); int rows = DBExecuteUtil.ExecuteSqlWithParams(strSql.ToString(), parameters.ToArray()); if (rows > 0) { return true; } else { return false; } }
protected CodeExpression CreateNewActionReference(ActionTreeNode node, List<CodeExpression> actionArguments, List<string> actionArgumentTypes) { var actionArgumentRuntimeTypes = new List<CodeExpression>(); foreach (var type in actionArgumentTypes) actionArgumentRuntimeTypes.Add(new CodeTypeOfExpression(source[type])); CodeExpression createMethodSignature = new CodeObjectCreateExpression( source[typeof (MethodSignature)], new CodeExpression[] { new CodeTypeOfExpression(node.Controller.FullName), new CodePrimitiveExpression(node.Name), new CodeArrayCreateExpression(source[typeof (Type)], actionArgumentRuntimeTypes.ToArray()) }); var constructionArguments = new[] { new CodeFieldReferenceExpression(new CodeThisReferenceExpression(), naming.ToMemberVariableName(serviceIdentifier)), new CodeTypeOfExpression(node.Controller.FullName), new CodePrimitiveExpression(node.Controller.Area), new CodePrimitiveExpression(naming.ToControllerName(node.Controller.Name)), new CodePrimitiveExpression(node.Name), createMethodSignature, new CodeArrayCreateExpression(source[typeof (ActionArgument)], actionArguments.ToArray()) }; return new CodeMethodInvokeExpression( new CodeMethodReferenceExpression( new CodePropertyReferenceExpression( new CodeFieldReferenceExpression(new CodeThisReferenceExpression(), naming.ToMemberVariableName(serviceIdentifier)), "ControllerReferenceFactory"), "CreateActionReference"), constructionArguments); }
public List<md_druginfo> SearchDruginfoList(string drugname, string standard, int producerid, string cust_name, string sub_name, orderbyEnum? orderby, string orderbyCol, int pageIndex, int pageSize, out string error) { error = string.Empty; try { #region Command string selectSql = string.Format("select * from md_druginfo WHERE TRUE "); StringBuilder conditionSb = new System.Text.StringBuilder(); List<MySqlParameter> paraList = new List<MySqlParameter>(); #endregion #region 搜索条件 if (!string.IsNullOrEmpty(drugname)) { conditionSb.Append(" AND drugname LIKE CONCAT('%', @drugname, '%') "); paraList.Add(new MySqlParameter("drugname", drugname)); } if (!string.IsNullOrEmpty(standard)) { conditionSb.Append(" AND standard LIKE CONCAT('%', @standard, '%') "); paraList.Add(new MySqlParameter("standard", standard)); } if (producerid > 0) { conditionSb.Append("AND producerid = @producerid"); paraList.Add(new MySqlParameter("producerid", producerid)); } if (!string.IsNullOrEmpty(cust_name)) { conditionSb.Append(" AND cust_name LIKE CONCAT('%', @cust_name, '%') "); paraList.Add(new MySqlParameter("cust_name", cust_name)); } if (!string.IsNullOrEmpty(sub_name)) { conditionSb.Append(" AND sub_name LIKE CONCAT('%', @sub_name, '%') "); paraList.Add(new MySqlParameter("sub_name", sub_name)); } #endregion #region 排序 分页 string orderbyStr = string.Empty; if (!string.IsNullOrEmpty(orderbyCol) && orderby.HasValue) orderbyStr = orderbyFormat.getSortStr(orderby.Value, orderbyCol); else orderbyStr = " order by pkid "; selectSql += conditionSb.ToString() + orderbyStr; if (pageIndex > 0) { selectSql += " LIMIT @pageIndex , @pageSize "; paraList.Add(new MySqlParameter("pageIndex", (pageIndex - 1) * pageSize)); paraList.Add(new MySqlParameter("pageSize", pageSize)); } #endregion #region 执行 var resultList = sqlHelper.ExecuteObjects<md_druginfo>(selectSql, paraList.ToArray()).ToList(); return resultList; #endregion } catch (Exception ex) { error += BaseTool.FormatExceptionMessage(ex); return null; } }
public List<patient_recipelist> SearchReciptList(int drid,int medical_rcd_id ,int hospital_id ,int patient_id ,string cust_name , DateTime? issue_time1 ,DateTime? issue_time2 , DateTime? createtime1 ,DateTime? createtime2,string check_result ,int fileid, orderbyEnum? orderby, string orderbyCol, int pageIndex, int pageSize, out string error) { error = string.Empty; try { #region Command string selectSql = string.Format("select *,COALESCE(info.name,'') as patient_name,info.gender as gender from patient_recipelist rec left join patient_info info on rec.patient_id=info.pkid WHERE TRUE "); StringBuilder conditionSb = new System.Text.StringBuilder(); List<MySqlParameter> paraList = new List<MySqlParameter>(); #endregion #region 搜索条件 if (drid > 0) { conditionSb.Append("AND drid = @drid"); paraList.Add(new MySqlParameter("drid", drid)); } if (medical_rcd_id > 0) { conditionSb.Append("AND medical_rcd_id = @medical_rcd_id"); paraList.Add(new MySqlParameter("medical_rcd_id", medical_rcd_id)); } if (hospital_id > 0) { conditionSb.Append("AND hospital_id = @hospital_id"); paraList.Add(new MySqlParameter("hospital_id", hospital_id)); } if (patient_id > 0) { conditionSb.Append("AND patient_id = @patient_id"); paraList.Add(new MySqlParameter("patient_id", patient_id)); } if (!string.IsNullOrEmpty(cust_name)) { conditionSb.Append(" AND cust_name = @cust_name "); paraList.Add(new MySqlParameter("cust_name", cust_name)); } if (issue_time1.HasValue) { conditionSb.Append(" AND DATEDIFF(issue_time,@issue_time1) >= 0 "); paraList.Add(new MySqlParameter("issue_time1", issue_time1.Value)); } if (issue_time2.HasValue) { conditionSb.Append(" AND DATEDIFF(issue_time,@issue_time2) <= 0 "); paraList.Add(new MySqlParameter("issue_time2", issue_time2.Value)); } if (createtime1.HasValue) { conditionSb.Append(" AND DATEDIFF(rec.createtime,@createtime1) >= 0 "); paraList.Add(new MySqlParameter("createtime1", createtime1.Value)); } if (createtime2.HasValue) { conditionSb.Append(" AND DATEDIFF(rec.createtime,@createtime2) <= 0 "); paraList.Add(new MySqlParameter("createtime2", createtime2.Value)); } if (fileid > 0) { conditionSb.Append("AND fileid = @fileid"); paraList.Add(new MySqlParameter("fileid", fileid)); } if (!string.IsNullOrEmpty(check_result)) { conditionSb.Append(" AND check_result = @check_result "); paraList.Add(new MySqlParameter("check_result", check_result)); } #endregion #region 排序 分页 string orderbyStr = string.Empty; if (!string.IsNullOrEmpty(orderbyCol) && orderby.HasValue) orderbyStr = orderbyFormat.getSortStr(orderby.Value, orderbyCol); else orderbyStr = " order by rec.pkid "; selectSql += conditionSb.ToString() + orderbyStr; if (pageIndex > 0) { selectSql += " LIMIT @pageIndex , @pageSize "; paraList.Add(new MySqlParameter("pageIndex", (pageIndex - 1) * pageSize)); paraList.Add(new MySqlParameter("pageSize", pageSize)); } #endregion #region 执行 var resultList = db.Database.SqlQuery<patient_recipelist>(selectSql, paraList.ToArray()).ToList(); return resultList; #endregion } catch (Exception ex) { error += BaseTool.FormatExceptionMessage(ex); return null; } }
/// <summary> 批量更新- 多条语句-事务 /// </summary public static int BatchUpdateDataMultiByTrans(string connStr, IList<UpdateSQLObj> batUpdateList, UserIDOP userID) { StringBuilder sb = new StringBuilder(); List<SqlParameter> paramList = new List<SqlParameter>(); string str = string.Empty; int index = 0; foreach (UpdateSQLObj sqlObj in batUpdateList) { sb.Append(" Update "); sb.Append(sqlObj.TableName); sb.Append(" Set "); bool isFirstValue = true; foreach (string key in sqlObj.DicParam.Keys) { if (isFirstValue) { isFirstValue = false; sb.Append(key); sb.Append("="); sb.Append("@Param" + index.ToString()); } else { sb.Append("," + key); sb.Append("="); sb.Append("@Param" + index.ToString()); } paramList.Add(new SqlParameter("@Param" + index.ToString(), sqlObj.DicParam[key])); index++; } if (sqlObj.pkName != null) { sb.Append(" Where ").Append(sqlObj.pkName).Append("=").Append("@Param" + index.ToString()).Append(";"); paramList.Add(new SqlParameter("@Param" + index.ToString(), sqlObj.pkVal)); index++; } else if (!string.IsNullOrEmpty(sqlObj.whereString)) { sb.Append(" Where ").Append(sqlObj.whereString).Append(";"); } } object _object = SqlHelper.ExecuteNonQueryTran(connStr, CommandType.Text, sb.ToString(), userID, paramList.ToArray()); return (_object == DBNull.Value) ? 0 : Convert.ToInt32(_object); }
private Model.BusLine GetBusLineInfo(string infoURL) { Model.BusLine blModel = new Model.BusLine(); string str = PostWebRequest(infoURL, "", encoding, false); Regex qzp = new Regex("<span class=\"red mr10\">.+?</span>站牌信息"); Regex qzp0 = new Regex("<span class=\"red mr10\">"); Regex qzp1 = new Regex("</span>站牌信息"); string routName = qzp.Match(str).Value; routName= qzp0.Replace(routName, ""); routName = qzp1.Replace(routName, ""); blModel.RouteName = routName; Regex qrm = new Regex("<div class=\"line_info\">[\\s\\S]+?<div class=\"line_point\">"); Regex qrm0 = new Regex("<p>.+?</p>"); Regex qrm1 = new Regex("<p>"); Regex qrm2 = new Regex("</p>"); string remarks = ""; remarks= qrm.Match(str).Value; remarks = qrm0.Match(remarks).Value; remarks = qrm1.Replace(remarks, ""); remarks = qrm2.Replace(remarks, ""); Regex qrmk = new Regex("<div class=\"line_time\">[\\s\\S]+?<div class=\"line_point\">"); Regex qrmk0 = new Regex("<p>.+?</p>"); Regex qrmk1 = new Regex("<p>"); Regex qrmk2 = new Regex("</p>"); string remarks2 = ""; remarks2 = qrmk.Match(str).Value; remarks2 = qrmk0.Match(remarks2).Value; remarks2 = qrmk1.Replace(remarks2, ""); remarks2 = qrmk2.Replace(remarks2, ""); remarks = remarks + remarks2; blModel.Remarks = remarks; List<string> stations = new List<string>(); Regex qstt = new Regex("<a href=\"http://bus.aibang.com/ningbo/station-[\\s\\S]+? name=\".+?\""); Regex qstt0 = new Regex("<a href=\"http://bus.aibang.com/ningbo/station-[\\s\\S]+? name=\""); Regex qstt1 = new Regex("\""); MatchCollection mCollection = qstt.Matches(str); foreach (Match m in mCollection) { string astt = qstt0.Replace(m.ToString(), ""); astt = qstt1.Replace(astt, ""); stations.Add(astt); } blModel.Station = stations.ToArray(); return blModel; }
public List<chk_demo> SearchChkTypeList( int typeid, string chk_item, orderbyEnum? orderby, string orderbyCol, int pageIndex, int pageSize, out string error) { error = string.Empty; try { #region Command string selectSql = string.Format("select * from chk_demo WHERE TRUE "); StringBuilder conditionSb = new System.Text.StringBuilder(); List<MySqlParameter> paraList = new List<MySqlParameter>(); #endregion #region 搜索条件 if (typeid > 0) { conditionSb.Append(" AND typeid = @typeid "); paraList.Add(new MySqlParameter("typeid", typeid)); } if (!string.IsNullOrEmpty(chk_item)) { conditionSb.Append(" AND chk_item like CONCAT('%'@,chk_item,'%') "); paraList.Add(new MySqlParameter("chk_item", chk_item)); } #endregion #region 排序 分页 string orderbyStr = string.Empty; if (!string.IsNullOrEmpty(orderbyCol) && orderby.HasValue) orderbyStr = orderbyFormat.getSortStr(orderby.Value, orderbyCol); else orderbyStr = " order by pkid "; selectSql += conditionSb.ToString() + orderbyStr; if (pageIndex > 0) { selectSql += " LIMIT @pageIndex , @pageSize "; paraList.Add(new MySqlParameter("pageIndex", (pageIndex - 1) * pageSize)); paraList.Add(new MySqlParameter("pageSize", pageSize)); } #endregion #region 执行 var resultList = db.Database.SqlQuery<chk_demo>(selectSql, paraList.ToArray()).ToList(); return resultList; #endregion } catch (Exception ex) { error += BaseTool.FormatExceptionMessage(ex); return null; } }
/// <summary> /// Pushes the version taken as a parameter /// Will return any changes that conflicts /// IMPORTANT: The version is not commited at the server before null is returned! /// </summary> /// <param name="path">The path to the repository to push</param> /// <param name="number">The version number used to identify the right version</param> /// <param name="log">The changes given by a number of text-.</param> /// <param name="user">The user to submit changes.</param> /// <returns> /// Any changes that conflicts or null if version is commited /// </returns> /// <exception cref="System.ArgumentNullException">Log can't be null</exception> /// <exception cref="System.ArgumentException">Log can't be empty</exception> public string[][] PushVersion(String path, int number, string[] log, User user) { if (log == null) throw new ArgumentNullException("Log can't be null"); if (log.Length < 1) throw new ArgumentException("Log can't be empty"); if (user == null) throw new ArgumentNullException("User can't be null"); if (String.IsNullOrEmpty(user.Name)) throw new ArgumentException("User's name is invalid: " + user.Name); if (String.IsNullOrEmpty(user.Password)) throw new ArgumentException("User's password is invalid"); if (user.MAC == null) throw new ArgumentNullException("User's MAC address is invalid (" + user.MAC + " and can therefore not push"); Console.WriteLine("[" + DateTime.Now + "]: " + "User is pushing to the server: " + user.MAC); //See if the user is known - if not: Throw an exception //Connect(user); var returnArray = new string[0][]; // Test that the version number is correct - otherwise we'll just store things at the wrong places. var vcs = new ServerVersionControlSystem(path, _fileSystem); var currentVersion = vcs.GetLatestVersionNumber(); if (currentVersion != number - 1) { throw new ArgumentException("Can not push version " + number + " to the server version " + currentVersion); } // If the last user that attempted to push is the same as the current user, no conflicts will occur. if (PushedLastVersion(user)) { // We can assume that everything has been resolved client side and execute all the changes made IList<AbstractChange> changeList = ChangeParser.ParseChanges(log).Where(item => item != null).ToList(); // Store the version SaveChanges(number, user, vcs, changeList); } else { String[] simpleChanges = SearchForSimpleChanges(log); String[,] complexChanges = SearchForComplexChanges(log); ISet<String> conflictingPathsOnServerSet = new SortedSet<string>(); ISet<String> conflictingPathsOnClientSet = new SortedSet<string>(); //Get paths to all text files in project directory and all sub directories. String absolutePath = vcs.GetFileSystemRoot() + path; IList<String> projectFilesList = new List<string>(Directory.GetFileSystemEntries(absolutePath, "*", SearchOption.AllDirectories).Where(s => s.Contains(FileSystem.META_DIR) == false)); // Discover potential conflicts for (int i = 0; i < projectFilesList.Count; i++) { projectFilesList[i] = projectFilesList[i].Substring(vcs.GetFileSystemRoot().Length); } foreach (String filePath in simpleChanges) { if (projectFilesList.Contains(filePath)) { conflictingPathsOnServerSet.Add(filePath); conflictingPathsOnClientSet.Add(filePath); } } for (int i = 0; i < complexChanges.Length; i++) { if (projectFilesList.Contains(complexChanges[i, 0])) { conflictingPathsOnServerSet.Add(complexChanges[i, 0]); conflictingPathsOnClientSet.Add(complexChanges[i, 1]); } } // If no conflicts arises we can save the change to the file system if (conflictingPathsOnServerSet.Count == 0) { SaveChanges(number, user, vcs, ChangeParser.ParseChanges(log)); } else // Otherwise we find the conflicting paths and return the contents of the file on the // server for the client to merge { IList<String> conflictingPathsOnServer = new List<string>(conflictingPathsOnServerSet); IList<String> conflictingPathsOnClient = new List<string>(conflictingPathsOnClientSet); var list = new List<string[]>(); for (int i = 0; i < conflictingPathsOnServer.Count; i++) { var fileList = new List<string>() { conflictingPathsOnClient[i] }; fileList.AddRange(vcs.ReadAllLines(conflictingPathsOnServer[i])); list.Add(fileList.ToArray()); } returnArray = list.ToArray(); } } // Save the last MAC adress _lastPushUser = user.Name; //AddToPushHistory(user); // Return the conflicts to the client return returnArray; }
public List<chk_info> SearchChkInfoList( int medical_id, int patient_id, int chk_type_id, int chk_demo_id, int fileid, int drid, orderbyEnum? orderby, string orderbyCol, int pageIndex, int pageSize, out string error) { error = string.Empty; try { #region Command string selectSql = string.Format("select *,pat.name as patient_name,chk_type.name as chk_name,rcd.createtime as chk_time from chk_info chk left join patient_medical_rcd rcd on chk.medical_id=rcd.pkid left join patient_info pat on chk.patient_id=pat.pkid left join chk_type on chk.chk_type_id on chk_type.pkid WHERE TRUE "); StringBuilder conditionSb = new System.Text.StringBuilder(); List<MySqlParameter> paraList = new List<MySqlParameter>(); #endregion #region 搜索条件 if (medical_id > 0) { conditionSb.Append(" AND medical_id = @medical_id "); paraList.Add(new MySqlParameter("medical_id", medical_id)); } if (patient_id > 0) { conditionSb.Append(" AND chk.patient_id = @patient_id "); paraList.Add(new MySqlParameter("patient_id", patient_id)); } if (chk_type_id > 0) { conditionSb.Append(" AND chk_type_id = @chk_type_id "); paraList.Add(new MySqlParameter("chk_type_id", chk_type_id)); } if (chk_demo_id > 0) { conditionSb.Append(" AND chk_demo_id = @chk_demo_id "); paraList.Add(new MySqlParameter("chk_demo_id", chk_demo_id)); } if (fileid > 0) { conditionSb.Append(" AND fileid = @fileid "); paraList.Add(new MySqlParameter("fileid", fileid)); } if (drid > 0) { conditionSb.Append(" AND patient_medical_rcd.drid = @drid "); paraList.Add(new MySqlParameter("drid", drid)); } #endregion #region 排序 分页 string orderbyStr = string.Empty; if (!string.IsNullOrEmpty(orderbyCol) && orderby.HasValue) orderbyStr = orderbyFormat.getSortStr(orderby.Value, orderbyCol); else orderbyStr = " order by chk.pkid "; selectSql += conditionSb.ToString() + orderbyStr; if (pageIndex > 0) { selectSql += " LIMIT @pageIndex , @pageSize "; paraList.Add(new MySqlParameter("pageIndex", (pageIndex - 1) * pageSize)); paraList.Add(new MySqlParameter("pageSize", pageSize)); } #endregion #region 执行 var resultList = db.Database.SqlQuery<chk_info>(selectSql, paraList.ToArray()).ToList(); return resultList; #endregion } catch (Exception ex) { error += BaseTool.FormatExceptionMessage(ex); return null; } }
/// <summary>批量修改销售开单导入状态 /// </summary> /// <param name="status">保存时:0 释放为正常,提交时:2 锁定</param> void ImportSaleBillStatus(string status) { List<string> listField = new List<string>(); foreach (DataGridViewRow dr in gvPurchaseList.Rows) { string relation_order = dr.Cells["relation_order"].Value == null ? "" : dr.Cells["relation_order"].Value.ToString(); if (!string.IsNullOrEmpty(relation_order)) { listField.Add(relation_order); } } Dictionary<string, string> Field = new Dictionary<string, string>(); Field.Add("is_occupy", status);//单据导入状态,0正常,1占用,2锁定 DBHelper.BatchUpdateDataByIn("批量修改销售开单导入状态", "tb_parts_sale_billing", Field, "order_num", listField.ToArray()); }
void UCOldPartsPalautusView_DeleteEvent(object sender, EventArgs e) { if (MessageBoxEx.Show("确认要删除吗?", "提示", MessageBoxButtons.OKCancel) != DialogResult.OK) { return; } List<SQLObj> listSql = new List<SQLObj>(); List<string> listField = new List<string>(); listField.Add(strPalautusId); Dictionary<string, string> comField = new Dictionary<string, string>(); comField.Add("enable_flag", Convert.ToInt32(DataSources.EnumEnableFlag.DELETED).ToString()); comField.Add("update_by", HXCPcClient.GlobalStaticObj.UserID);//修改人Id comField.Add("update_name", HXCPcClient.GlobalStaticObj.UserName);//修改人姓名 comField.Add("update_time", Common.LocalDateTimeToUtcLong(HXCPcClient.GlobalStaticObj.CurrentDateTime).ToString());//修改时间 bool flag = DBHelper.BatchUpdateDataByIn("删除宇通旧件返厂单", "tb_maintain_oldpart_recycle", comField, "return_id", listField.ToArray()); if (flag) { MessageBoxEx.Show("删除成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); uc.BindPageData(); deleteMenuByTag(this.Tag.ToString(), "UCOldPartsPalautusView"); } else { MessageBoxEx.Show("删除失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public void ExportingImportingVMConfigAsTemplateforRepeatableUsage() { StartTest(MethodBase.GetCurrentMethod().Name, testStartTime); // Create a new Azure quick VM string newAzureQuickVMName = Utilities.GetUniqueShortName("PSTestVM"); if (string.IsNullOrEmpty(imageName)) imageName = vmPowershellCmdlets.GetAzureVMImageName(new[] { "Windows" }, false); vmPowershellCmdlets.NewAzureQuickVM(OS.Windows, newAzureQuickVMName, serviceName, imageName, username, password, locationName); // New-AzureQuickVM Console.WriteLine("VM is created successfully: -Name {0} -ServiceName {1}", newAzureQuickVMName, serviceName); // starting the test. string path = ".\\mytestvmconfig1.xml"; PersistentVMRoleContext vmRole = vmPowershellCmdlets.ExportAzureVM(newAzureQuickVMName, serviceName, path); // Export-AzureVM Console.WriteLine("Exporting VM is successfully done: path - {0} Name - {1}", path, vmRole.Name); vmPowershellCmdlets.RemoveAzureVM(newAzureQuickVMName, serviceName); // Remove-AzureVM Assert.AreEqual(null, vmPowershellCmdlets.GetAzureVM(newAzureQuickVMName, serviceName)); Console.WriteLine("The VM is successfully removed: {0}", newAzureQuickVMName); List<PersistentVM> VMs = new List<PersistentVM>(); foreach (var pervm in vmPowershellCmdlets.ImportAzureVM(path)) // Import-AzureVM { VMs.Add(pervm); Console.WriteLine("The VM, {0}, is imported.", pervm.RoleName); } for (int i = 0; i < 3; i++) { try { vmPowershellCmdlets.NewAzureVM(serviceName, VMs.ToArray()); // New-AzureVM Console.WriteLine("All VMs are successfully created."); foreach (var vm in VMs) { Console.WriteLine("created VM: {0}", vm.RoleName); } break; } catch (Exception e) { if (e.ToString().ToLowerInvariant().Contains("currently in use") && i != 2) { Console.WriteLine("The removed VM is still using the vhd"); Thread.Sleep(120000); continue; } else { Assert.Fail("error during New-AzureVM: {0}", e.ToString()); } } } // Verify PersistentVMRoleContext vmRoleCtxt = vmPowershellCmdlets.GetAzureVM(newAzureQuickVMName, serviceName); Assert.AreEqual(newAzureQuickVMName, vmRoleCtxt.Name, true); // Cleanup vmPowershellCmdlets.RemoveAzureVM(newAzureQuickVMName, serviceName); Assert.AreEqual(null, vmPowershellCmdlets.GetAzureVM(newAzureQuickVMName, serviceName)); pass = true; }
/// <summary> /// 对出诊表各个字段查询 /// </summary> /// <param name="hospital_id"></param> /// <param name="drid"></param> /// <param name="visit_date1"></param> /// <param name="visit_date2"></param> /// <param name="visit_time"></param> /// <param name="service_type"></param> /// <param name="status"></param> /// <param name="createtime1"></param> /// <param name="createtime2"></param> /// <param name="orderby">顺序 降序</param> /// <param name="orderbyCol">排序字段,传入dr_visit的字段,不需要前缀</param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="error"></param> /// <returns>null则出错</returns> public List<dr_addvisit> SearchVisitList(int hospital_id, int drid, DateTime? visit_date1, DateTime? visit_date2, string visit_time, int service_type, int status, DateTime? createtime1, DateTime? createtime2, orderbyEnum? orderby, string orderbyCol, int pageIndex, int pageSize, out string error) { error = string.Empty; try { #region Command string selectSql = string.Format("select * from dr_addvisit WHERE TRUE "); StringBuilder conditionSb = new System.Text.StringBuilder(); List<MySqlParameter> paraList = new List<MySqlParameter>(); #endregion #region 搜索条件 if (hospital_id > 0) { conditionSb.Append("AND hospital_id = @hospital_id"); paraList.Add(new MySqlParameter("hospital_id", hospital_id)); } if (drid > 0) { conditionSb.Append("AND drid = @drid"); paraList.Add(new MySqlParameter("drid", drid)); } if (visit_date1.HasValue) { conditionSb.Append(" AND DATEDIFF(visit_date,@visit_date1) >= 0 "); paraList.Add(new MySqlParameter("visit_date1", visit_date1.Value)); } if (visit_date2.HasValue) { conditionSb.Append(" AND DATEDIFF(visit_date,@visit_date2) <= 0 "); paraList.Add(new MySqlParameter("visit_date2", visit_date2.Value)); } if (!string.IsNullOrEmpty(visit_time)) { conditionSb.Append(" AND visit_time = @visit_time "); paraList.Add(new MySqlParameter("visit_time", visit_time)); } if (service_type > 0) { conditionSb.Append("AND service_type = @service_type"); paraList.Add(new MySqlParameter("service_type", service_type)); } if (status > 0) { conditionSb.Append("AND status = @status"); paraList.Add(new MySqlParameter("status", status)); } if (createtime1.HasValue) { conditionSb.Append(" AND DATEDIFF(createtime,@createtime1) >= 0 "); paraList.Add(new MySqlParameter("createtime1", createtime1.Value)); } if (createtime2.HasValue) { conditionSb.Append(" AND DATEDIFF(createtime,@createtime2) <= 0 "); paraList.Add(new MySqlParameter("createtime2", createtime2.Value)); } #endregion #region 排序 分页 string orderbyStr = string.Empty; if (!string.IsNullOrEmpty(orderbyCol) && orderby.HasValue) orderbyStr = orderbyFormat.getSortStr(orderby.Value, orderbyCol); else orderbyStr = " order by pkid "; selectSql += conditionSb.ToString() + orderbyStr; if (pageIndex > 0) { selectSql += " LIMIT @pageIndex , @pageSize "; paraList.Add(new MySqlParameter("pageIndex", (pageIndex - 1) * pageSize)); paraList.Add(new MySqlParameter("pageSize", pageSize)); } #endregion #region 执行 var resultList = db.Database.SqlQuery<dr_addvisit>(selectSql, paraList.ToArray()).ToList(); return resultList; #endregion } catch (Exception ex) { error += BaseTool.FormatExceptionMessage(ex); return null; } }
public Video[] GetAllVideo() { List<Video> myVideos = new List<Video>(); SqlConnection myConn = new SqlConnection(connstring); myConn.Open(); SqlCommand mySqlCommand = new SqlCommand("select * from video", myConn); SqlDataReader reader = mySqlCommand.ExecuteReader(); while (reader.Read()) { Video myVideo = new Video(); object id = reader["Id"]; if(id != null) { int videoId = -1; if (!int.TryParse(id.ToString(), out videoId)) { throw new Exception("Failed to parse Id of video."); } myVideo.Id = videoId; } myVideo.Name = reader["Name"].ToString(); myVideo.Url = reader["Url"].ToString(); myVideos.Add(myVideo); } myConn.Close(); return myVideos.ToArray(); }
private static InfoItem[] GetTuple(MessageContext context) { if (context.Command.Verb == Verb.Create) { var items = new List<InfoItem>(); var commandFactory = context.Host.NodeHost.MessageProducer; foreach (var node in context.Host.NodeHost.Nodes) { if (commandFactory.IsProduce(context, node)) { bool isCare = false; foreach (var item in context.InfoTuplePair.ValueTuple) { if (node.IsCareforElement(item.Element)) { isCare = true; items.Add(item); } } if (isCare) { foreach (var element in node.GetInfoIdElements()) { items.Add(InfoItem.Create(element, string.Empty)); } } } } return items.ToArray(); } return context.TowInfoTuple.SingleInfoTuple; }
/// <summary>批量修改采购计划单/销售订单的导入状态 /// </summary> /// <param name="status">保存时:0 释放为正常,提交时:2 锁定</param> void ImportPurchasePlanStatus(string status) { List<string> listFieldPurchasePlan = new List<string>(); List<string> listFieldSale = new List<string>(); foreach (DataGridViewRow dr in gvPurchaseList.Rows) { if (dr.Cells["parts_code"].Value == null) { continue; } string relation_order = dr.Cells["relation_order"].Value == null ? "" : dr.Cells["relation_order"].Value.ToString(); string ImportType = dr.Cells["ImportType"].Value == null ? "" : dr.Cells["ImportType"].Value.ToString(); if (!string.IsNullOrEmpty(relation_order)) { if (ImportType == "采购计划单") { listFieldPurchasePlan.Add(relation_order); } else if (ImportType == "销售订单") { listFieldSale.Add(relation_order); } } } Dictionary<string, string> Field = new Dictionary<string, string>(); if (listFieldPurchasePlan.Count > 0) { Field.Add("import_status", status);//单据导入状态,0正常,1占用,2锁定 DBHelper.BatchUpdateDataByIn("批量修改采购计划单导入状态", "tb_parts_purchase_plan", Field, "order_num", listFieldPurchasePlan.ToArray()); } if (listFieldSale.Count > 0) { Field.Add("is_occupy", status);//单据导入状态,0正常,1占用,2锁定 DBHelper.BatchUpdateDataByIn("批量修改销售订单单导入状态", "tb_parts_sale_order", Field, "order_num", listFieldSale.ToArray()); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(PubtypeEntity model) { StringBuilder strSql = new StringBuilder(); List<SqlParameter> parameters = new List<SqlParameter>(); strSql.Append("update Pubtype set "); if (!string.IsNullOrEmpty(model.typename)) { strSql.Append(" typename = @typename , "); parameters.Add(new SqlParameter("@typename", model.typename)); } strSql.Append(" enable = @enable , "); parameters.Add(new SqlParameter("@enable", model.enable)); strSql = strSql.Remove(strSql.Length - 2, 2); strSql.Append(" where id=@id "); parameters.Add(new SqlParameter("@id", model.id)); int rows = DBExecuteUtil.ExecuteSqlWithParams(strSql.ToString(), parameters.ToArray()); if (rows > 0) { return true; } else { return false; } }