public IList<AddressInfo> GetAddress(int userID) { SqlHelper objSqlHelper = new SqlHelper(); List<AddressInfo> Addresss = new List<AddressInfo>(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@userID", SqlDbType.Int, 4); objParams[0].Value = userID; SqlDataReader reader = objSqlHelper.ExecuteReader("je_Ad_GetAddress", objParams); while (reader.Read()) { AddressInfo item = new AddressInfo(); item.AddressID = reader.GetInt32(reader.GetOrdinal("addressID")); item.AddressName = reader.GetString(reader.GetOrdinal("addressName")); item.Address = reader.GetString(reader.GetOrdinal("address")); item.Post = reader.GetString(reader.GetOrdinal("Post")); item.Telephone = reader.GetString(reader.GetOrdinal("Telephone")); item.IsDefault = reader.GetBoolean(reader.GetOrdinal("isDefault")); item.Province = reader.GetString(reader.GetOrdinal("Province")); item.City = reader.GetString(reader.GetOrdinal("City")); item.SendType = reader.GetInt32(reader.GetOrdinal("SendType")); item.Name = reader.GetString(reader.GetOrdinal("Name")); Addresss.Add(item); } reader.Close(); return Addresss; }
private void buttonX2_Click(object sender, EventArgs e) { if (listView1.CheckedItems.Count != 0) { SqlHelper help = new SqlHelper(); string condition = " where " + "Teacher='" + listView1.CheckedItems[0].SubItems[1].Text + "'"; if (help.delete("Teachers_Data", condition) > 0) { MessageBox.Show("删除成功"); } else { MessageBox.Show("删除失败"); } listView1.Items.Clear(); setTbEnable(); clear_listview(); totalpage = pageshow.totalpage("select * from Teachers_Data", pagesize, "Teachers_Data"); labPageAll.Text = totalpage + ""; textBoxNow.Text = currentpage.ToString(); DataTable dt = pageshow.ListviewShow("select * from Teachers_Data", currentpage, pagesize, "Teachers_Data"); UIShow show = new UIShow(); show.teachers_listview_write(dt, listView1); groupBox1.SendToBack(); } }
public IList<CategoryInfo> GetCategory(CategoryType categoryType, int categoryID) { SqlHelper objSqlHelper = new SqlHelper(); List<CategoryInfo> categorys = new List<CategoryInfo>(); SqlParameter[] objParams = new SqlParameter[2]; objParams[0] = new SqlParameter("@categoryType", SqlDbType.Int, 4); objParams[1] = new SqlParameter("@categoryID", SqlDbType.Int, 4); objParams[0].Value = (int)categoryType; objParams[1].Value = categoryID; SqlDataReader reader = objSqlHelper.ExecuteReader("je_Cat_GetCategory", objParams); ; while (reader.Read()) { CategoryInfo item = new CategoryInfo(); item.CategoryID = reader.GetInt32(reader.GetOrdinal("categoryID")); item.CategoryName = reader.GetString(reader.GetOrdinal("categoryName")); item.ParentID = reader.GetInt32(reader.GetOrdinal("parentID")); item.IsMain = reader.GetBoolean(reader.GetOrdinal("IsMain")); categorys.Add(item); } reader.Close(); objSqlHelper.close(); return categorys; }
public AddressInfo GetAddressByID() { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@userName", SqlDbType.VarChar); objParams[0].Value = GetUserName(); SqlDataReader reader = objSqlHelper.ExecuteReader("je_Ad_GetAddressByID", objParams); AddressInfo item = new AddressInfo(); while (reader.Read()) { item.UserName = reader.GetString(reader.GetOrdinal("userName")); item.AddressName = reader.GetString(reader.GetOrdinal("addressName")); item.Address = reader.GetString(reader.GetOrdinal("address")); item.Post = reader.GetString(reader.GetOrdinal("Post")); item.Telephone = reader.GetString(reader.GetOrdinal("Telephone")); item.Province = reader.GetString(reader.GetOrdinal("Province")); item.City = reader.GetString(reader.GetOrdinal("City")); item.SendType = reader.GetInt32(reader.GetOrdinal("SendType")); item.PayType = reader.GetInt32(reader.GetOrdinal("PayType")); item.Name = reader.GetString(reader.GetOrdinal("Name")); item.Price = reader.GetDecimal(reader.GetOrdinal("Price")); item.Balance = reader.GetDecimal(reader.GetOrdinal("Balance")); } reader.Close(); return item; }
/// <summary> /// Создает новую задачу. /// </summary> /// <param name="task">Задача.</param> /// <returns>Идентификатор созданной задачи.</returns> public int Create(TaskItem task) { using (var sqlh = new SqlHelper()) { return sqlh.ExecScalar<int>(@" insert into Task.task ( number, task_prefix, header, mem, deadline, priority, performer, author ) values ( @Number, (select top 1 p.task_prefix from Task.task_prefix p where p.code = @Prefix), @Header, @Mem, @Deadline, @Priority, @Performer, @Author ) select scope_identity()", task); } }
/// <summary> /// ����������ѯ�����б� /// </summary> /// <param name="where"></param> /// <returns></returns> public List<BuilderObject> GetBuilderByName(string where) { SqlHelper sh = new SqlHelper(); ds = new DataSet(); ds = sh.selectAll("builderObject", "buildName like '%" + where + "%'"); list = new List<BuilderObject>(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { BuilderObject boTemp = new BuilderObject(); boTemp.BuilId = int.Parse(ds.Tables[0].Rows[i][0].ToString()); boTemp.BuilName = ds.Tables[0].Rows[i][1].ToString(); // boTemp.BuilItemID = ds.Tables[0].Rows[i][2].ToString(); boTemp.BuilHeight = ds.Tables[0].Rows[i][2].ToString(); boTemp.BuilArea = ds.Tables[0].Rows[i][3].ToString(); boTemp.BuilInfo = ds.Tables[0].Rows[i][4].ToString(); boTemp.BuilLongitude = ds.Tables[0].Rows[i][5].ToString(); boTemp.BuilLatitude = ds.Tables[0].Rows[i][6].ToString(); boTemp.BuidObjectID = ds.Tables[0].Rows[i][7].ToString(); list.Add(boTemp); } return list; }
/// <summary> /// ������Ϣ��ID ��ѯ������Ϣ /// </summary> /// <param name="itemID"></param> /// <returns></returns> public List<BuilderObject> GetBuilderInfo(string ObjectID) { SqlHelper sh = new SqlHelper(); ds = new DataSet(); ds = sh.selectAll("builderObject", "buildObjectID='" + ObjectID + "'"); list = new List<BuilderObject>(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { BuilderObject boTemp = new BuilderObject(); boTemp.BuilId = int.Parse(ds.Tables[0].Rows[i][0].ToString()); boTemp.BuilName = ds.Tables[0].Rows[i][1].ToString(); //������ǵ�i�еĵ�1�е����� // boTemp.BuilItemID = ds.Tables[0].Rows[i][2].ToString(); boTemp.BuilHeight = ds.Tables[0].Rows[i][2].ToString(); boTemp.BuilArea = ds.Tables[0].Rows[i][3].ToString(); boTemp.BuilInfo = ds.Tables[0].Rows[i][4].ToString(); boTemp.BuilLongitude = ds.Tables[0].Rows[i][5].ToString(); boTemp.BuilLatitude = ds.Tables[0].Rows[i][6].ToString(); boTemp.BuidObjectID = ds.Tables[0].Rows[i][7].ToString(); //Tables��Rows���Ǽ��ϣ��������ǿ���ͨ���������������еij�Ա list.Add(boTemp); } return list; }
public int DeleteTeacher(TeacherInfo teacher) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@ID", teacher.TeacherID); return objSqlHelper.ExecuteNonQuery("je_TE_DeleteTeacher", objParams); }
public IList<ReviewInfo> GetReview(ReviewType rt, int ID) { SqlHelper objSqlHelper = new SqlHelper(); List<ReviewInfo> reviews = new List<ReviewInfo>(); SqlParameter[] objParams = new SqlParameter[2]; objParams[0] = new SqlParameter("@reviewType", SqlDbType.Int, 4); objParams[1] = new SqlParameter("@ID", SqlDbType.Int, 4); objParams[0].Value = (int)rt; objParams[1].Value = ID; SqlDataReader reader = objSqlHelper.ExecuteReader("je_Reviews_GetReview", objParams); while (reader.Read()) { ReviewInfo item = new ReviewInfo(); item.ReviewID = reader.GetInt32(reader.GetOrdinal("ReviewID")); item.BookID = reader.GetInt32(reader.GetOrdinal("bookID")); item.PostIP = reader.GetString(reader.GetOrdinal("postIP")); item.PostTime = reader.GetDateTime(reader.GetOrdinal("postTime")); item.RateID = reader.GetInt32(reader.GetOrdinal("rate")); item.UserName = reader.GetString(reader.GetOrdinal("userName")); item.StatusID = reader.GetInt32(reader.GetOrdinal("status")); item.Content = reader.GetString(reader.GetOrdinal("content")); reviews.Add(item); } reader.Close(); return reviews; }
/// <summary> /// 窗体初始化 /// </summary> public FormMailPartition() { InitializeComponent(); wrapper = ModBusTCPIPWrapper.Instance(); obrWrapper = new OBRClientWrapper(); sqlHandler = SqlHelper.Instance(); //委托实例化 UpdateUIFunction = new receiveUpdateUI(UpdateUIAction); UpdateBarcodeFunction = new barcodeUpdateUI(UpdateBarcodeAction); UpdateTimerFunction = new UpdataTimer(UpdateTimerAction); UpdatePicFunction = new UpdatePic(UpdatePicAction); //PLC IP 文本框及状态更新 this.textBoxPLCIP.Text = ConfigurationManager.AppSettings["PLCIP"]; this.pictureBoxPLCConn.Image = Flag.BmpGray; //OBR IP 文本框及状态更新 this.textBoxOBRIP.Text = ConfigurationManager.AppSettings["OBRIP"]; this.pictureBoxOBRConn.Image = Flag.BmpGray; //连接状态更新计时器开启 this.timerStatus.Start(); //开启服务端监听即接收线程和客户端发送线程 StartListenThread(); StartConnectPLCThread(); StartConnectOBRThread(); //开启更新UI文本框线程 UpdateUIThread(); }
public int DeleteTitleCss(int titleCssID) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@cssID", titleCssID); return objSqlHelper.ExecuteNonQuery("je_Tc_DeleteTitleCss", objParams); }
public static string FindMaximumValue(int OperationValue) { string strMaxValue=""; try { SqlHelper SH = new SqlHelper(); SH.openconnection(); SqlCommand cmdAuthors = new SqlCommand("sp_find_maximum", SH.conn); cmdAuthors.CommandType = CommandType.StoredProcedure; cmdAuthors.Parameters.Clear(); cmdAuthors.Parameters.Add("@OutPutValue", SqlDbType.Int); cmdAuthors.Parameters["@OutPutValue"].Direction = ParameterDirection.Output; cmdAuthors.Parameters.Add("@Operation", SqlDbType.Int); cmdAuthors.Parameters["@Operation"].Value = OperationValue; cmdAuthors.ExecuteNonQuery(); strMaxValue = cmdAuthors.Parameters["@OutPutValue"].Value.ToString(); SH.closeconnection(); } catch (Exception) { throw new System.NotImplementedException(); } return strMaxValue; }
/// <summary> /// Создает новый учебный план. /// </summary> /// <param name="plan">Учебный план.</param> /// <returns>Идентификатор созданного учебного плана.</returns> public int Create(PlanItem plan) { using (var sqlh = new SqlHelper()) { return sqlh.ExecScalar<int>(@" insert into TrainingPlan.specialty_plan ( name, specialty_detail, semester, lesson_type, discipline, auditory ) values ( @Name, @SpecialtyDetail, @Semester, @LessonType, @Discipline, @Auditory ) select scope_identity()", plan); } }
public int DeleteSend(int SendID) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@sendID", SendID); return objSqlHelper.ExecuteNonQuery("je_Send_DeleteSend", objParams); }
public static SqlCommand CreateCommand(string sql, CommandType type, List<SqlParameter> param) { //connectionstring(); //SqlConnection con = new SqlConnection(strConnection); //con.Open(); SqlHelper SH = new SqlHelper(); SH.openconnection(); SqlCommand cmd = new SqlCommand(sql,SH.conn); cmd.CommandType = CommandType.StoredProcedure; if (param.Count > 0) { foreach (SqlParameter p in param) { if (p != null) { cmd.Parameters.Add(p); } } } //sqlhelp.closeconnection(); return cmd; SH.closeconnection(); }
public int DeleteCatena(int catenaID) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@catenaID", catenaID); return objSqlHelper.ExecuteNonQuery("je_Ct_DeleteCatena", objParams); }
public int DeleteHelp(int helpID) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@helpID", helpID); return objSqlHelper.ExecuteNonQuery("je_Help_DeleteHelp", objParams); }
public int DeleteFavBookByID(int bookID) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@bookID", bookID); return objSqlHelper.ExecuteNonQuery("je_FBook_DeleteFavBooksByID", objParams); }
public IList<ValoresFuente> Valores(Ciudad city, int limite, dynamic options = null) { var sql = string.Format("select {0} * ", limite == 0 ? "" : "top " + limite); sql += " from v_predio where id_ciudad = @id order by clave, num_construccion"; var str = ConfigurationManager.ConnectionStrings["riesgos"].ConnectionString; var conn = new SqlConnection(str); conn.Open(); var mapa = new Dictionary<string, ValoresFuente>(); var reader = new SqlHelper(conn).ExecuteReader(sql, new { id = city.Id }); while (reader.Read()) { var temp = new ValoresFuente(); temp.Tipo = "construccion"; Utils.FillDict(reader, temp); var cod = temp.GetString("clave"); var num = temp.GetString("num_construccion") ?? "0"; var key = Utils.MakeKey(cod, num); if (!mapa.ContainsKey(key)) { temp.Codigo1 = cod; temp.Codigo2 = num; temp.IdItem = temp["id"]; mapa[key] = temp; } var cat = temp.GetString("clave_dato"); if (!string.IsNullOrEmpty(cat)) mapa[key][cat] = temp.GetString("valor_texto"); temp.Remove("clave_dato"); temp.Remove("valor_texto"); } reader.Close(); conn.Close(); return mapa.Values.ToList(); }
public static SqlHelper Instance() { if (SqlHelper._instance == null) SqlHelper._instance = new SqlHelper(); return SqlHelper._instance; }
public int DeleteGuestBookByID(int gbID) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@gbID", gbID); return objSqlHelper.ExecuteNonQuery("je_Gb_DeleteGuestBookByID", objParams); }
/// <summary> /// Получает задачу по идентификатору. /// </summary> /// <param name="id">Идентификатор.</param> /// <returns>Задача.</returns> public TaskItem Get(int id) { using (var sqlh = new SqlHelper()) { return sqlh.ExecMapping<TaskItem>(@" select t.task Id, t.number Number, p.code Prefix, t.header Header, t.mem Mem, t.created Created, t.deadline Deadline, t.priority Priority, t.performer Performer, t.author Author, t.is_perform IsPerform, t.is_open IsOpen, t.difficult Difficult, t.pull_request_url PullRequestUrl from Task.task t join Task.task_prefix p on p.task_prefix = t.task_prefix where t.task = @id", new { id }); } }
public string GetImpersonatedLoginFor(string login) { if (!_settings.IsImpersonationEnabled) { return null; } var sql = new SqlHelper("SELECT p.login_name, p.status FROM table_user u, table_user p WHERE u.login_name = {0} AND p.objid = u.user2proxy_user"); sql.Parameters.Add("login", login); using (var result = sql.ExecuteReader()) { while (result.Read()) { var status = Convert.ToInt32(result["status"]); var impersonatedLoginFor = result["login_name"].ToString(); if (status == 1) { return impersonatedLoginFor; } else { _logger.LogDebug( "Cancelling the impersonation of INACTIVE user {0} by user {1}.".ToFormat(impersonatedLoginFor, login)); cancelImpersonation(login, impersonatedLoginFor); return null; } } return null; } }
protected void InitData() { SqlHelper mydata = new SqlHelper(); GridView1.DataSource = mydata.GetDataReader("select * from Musictype"); GridView1.DataBind(); }
public static void createImpersonationFor(string impersonatingUserLogin, string userLoginBeingImpersonated) { var sql = new SqlHelper("update table_user set user2proxy_user = (select objid from table_user where login_name = {0}) where login_name = {1}"); sql.Parameters.Add("login", userLoginBeingImpersonated); sql.Parameters.Add("proxylogin", impersonatingUserLogin); sql.ExecuteNonQuery(); }
public IList<FriendLinkInfo> GetLinks(LinkItemType linkType) { SqlHelper objSqlHelper = new SqlHelper(); List<FriendLinkInfo> friendlinks = new List<FriendLinkInfo>(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@linkType", SqlDbType.Int, 4); objParams[0].Value = (int)linkType; SqlDataReader reader = objSqlHelper.ExecuteReader("je_Link_GetLinks", objParams); ; objParams[0].Value = (int)linkType; while (reader.Read()) { FriendLinkInfo item = new FriendLinkInfo(); item.LinkID = reader.GetInt32(reader.GetOrdinal("linkID")); item.LinkName = reader.GetString(reader.GetOrdinal("linkName")); item.LinkURL = reader.GetString(reader.GetOrdinal("linkURL")); item.LinkLogo = reader.GetString(reader.GetOrdinal("linkLogo")); item.LinkOrder = reader.GetInt32(reader.GetOrdinal("linkOrder")); item.IsMain = reader.GetBoolean(reader.GetOrdinal("linkMain")); item.IsArrow = reader.GetBoolean(reader.GetOrdinal("linkArrow")); friendlinks.Add(item); } reader.Close(); return friendlinks; }
/// <summary> /// Создает новую аудиторию. /// </summary> /// <param name="auditory">Аудитория.</param> /// <returns>Идентификатор созданной аудитории.</returns> public int Create(AuditoryItem auditory) { using (var sqlh = new SqlHelper()) { return sqlh.ExecScalar<int>(@" insert into Auditory.auditory ( number, full_name, memo, level, capacity ) values ( @Number, @FullName, @Memo, @Level, @Capacity ) select scope_identity()", auditory); } }
public static void setAllowProxy(string userLogin, bool canProxy) { var sql = new SqlHelper("update table_employee set allow_proxy = {0} where objid = (select objid from table_user where login_name = {1})"); sql.Parameters.Add("canProxy", canProxy ? 1 : 0); sql.Parameters.Add("login", userLogin); sql.ExecuteNonQuery(); }
public void Import() { var mySqlHelper = new MySqlHelper(MySql); var sqlHelper = new SqlHelper(SqlServer); var mysql = string.Format("select * from qdt_deal"); var dt = mySqlHelper.ExecuteDataTable(mysql); var sql = ""; var n = 0; for (var i = 0; i < dt.Rows.Count; i++) { sql += "INSERT INTO qdt_deal (id,name,sub_name,cate_id,user_id,description,is_effect,is_delete,borrow_amount,min_loan_money," + "repay_time,rate,create_time,update_time,is_recommend,buy_count,load_money,repay_money,start_time,success_time," + "repay_start_time,last_repay_time,next_repay_time,bad_time,deal_status,enddate,services_fee,is_send_bad_msg,bad_msg,loantype," + "warrant,titlecolor,is_send_contract,max_loan_money,icon,repay_time_type) " + "VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}','{23}','{24}','{25}','{26}','{27}','{28}','{29}','{30}','{31}','{32}','{33}','{34}','{35}');\r\n" .FormatWith(dt.Rows[i]["id"], dt.Rows[i]["name"], dt.Rows[i]["sub_name"], dt.Rows[i]["cate_id"], dt.Rows[i]["user_id"], dt.Rows[i]["description"].ToString().Replace('\'', '\"').Replace("./help/id-", "/Help/Index/").Replace("?", ""), dt.Rows[i]["is_effect"], dt.Rows[i]["is_delete"], dt.Rows[i]["borrow_amount"], dt.Rows[i]["min_loan_money"], dt.Rows[i]["repay_time"], dt.Rows[i]["rate"], GetTime(dt.Rows[i]["create_time"]), GetTime(dt.Rows[i]["update_time"]), dt.Rows[i]["is_recommend"], dt.Rows[i]["buy_count"], dt.Rows[i]["load_money"], dt.Rows[i]["repay_money"], GetTime(dt.Rows[i]["start_time"]), GetTime(dt.Rows[i]["success_time"]), GetTime(dt.Rows[i]["repay_start_time"]), GetTime(dt.Rows[i]["last_repay_time"]), GetTime(dt.Rows[i]["next_repay_time"]), GetTime(dt.Rows[i]["bad_time"]), dt.Rows[i]["deal_status"], dt.Rows[i]["enddate"], dt.Rows[i]["services_fee"], dt.Rows[i]["is_send_bad_msg"], dt.Rows[i]["bad_msg"], dt.Rows[i]["loantype"], dt.Rows[i]["warrant"], dt.Rows[i]["titlecolor"], dt.Rows[i]["is_send_contract"], dt.Rows[i]["max_loan_money"], dt.Rows[i]["icon"], dt.Rows[i]["repay_time_type"]).Replace("'NULL'","NULL"); if ((i + 1) % 10 != 0) continue; n += sqlHelper.ExecuteNonQuery(sql); sql = ""; } if (!string.IsNullOrWhiteSpace(sql)) n += sqlHelper.ExecuteNonQuery(sql); Console.WriteLine("成功导入deal表:" + n + "条数据!"); }
public IList<ValoresFuente> Valores(Ciudad city, int limite, dynamic options = null) { var top = limite > 0 ? "top " + limite : ""; var sql = "select " + top + " * from sta_elena order by codigo_catastral"; var str = ConfigurationManager.ConnectionStrings["riesgos"].ConnectionString; var conn = new SqlConnection(str); conn.Open(); var reader = new SqlHelper(conn).ExecuteReader(sql); var mapa = new Dictionary<string, ValoresFuente>(); var i = 0; while (reader.Read()) { i++; var temp = new ValoresFuente(); Utils.FillDict(reader, temp); var clave = temp.GetString("codigo_catastral"); if (mapa.ContainsKey(clave)) continue; var manzana = GetManzana(clave); temp.Tipo = "construccion"; temp.Codigo1 = clave; temp.Codigo2 = manzana; temp.IdItem = i; temp["clave"] = clave; temp["manzana"] = manzana; mapa[clave] = temp; } reader.Close(); conn.Close(); return mapa.Values.ToList(); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Hi.Model.DIS_GoodsStock model, SqlTransaction Tran) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [DIS_GoodsStock]("); strSql.Append("[DisID],[CompID],[GoodsID],[IsSale],[GoodsInfo],[BatchNO],[validDate],[StockTotalNum],[StockUseNum],[StockNum],[MinAlertNum],[MaxAlertNum],[Price],[CreateUserID],[CreateDate],[ts],[modifyuser])"); strSql.Append(" values ("); strSql.Append("@DisID,@CompID,@GoodsID,@IsSale,@GoodsInfo,@BatchNO,@validDate,@StockTotalNum,@StockUseNum,@StockNum,@MinAlertNum,@MaxAlertNum,@Price,@CreateUserID,@CreateDate,@ts,@modifyuser)"); strSql.Append(";select @@Identity"); SqlParameter[] parameters = { new SqlParameter("@DisID", SqlDbType.Int), new SqlParameter("@CompID", SqlDbType.Int), new SqlParameter("@GoodsID", SqlDbType.BigInt), new SqlParameter("@IsSale", SqlDbType.Int), new SqlParameter("@GoodsInfo", SqlDbType.VarChar, 200), new SqlParameter("@BatchNO", SqlDbType.VarChar, 100), new SqlParameter("@validDate", SqlDbType.DateTime), new SqlParameter("@StockTotalNum", SqlDbType.Decimal), new SqlParameter("@StockUseNum", SqlDbType.Decimal), new SqlParameter("@StockNum", SqlDbType.Decimal), new SqlParameter("@MinAlertNum", SqlDbType.Decimal), new SqlParameter("@MaxAlertNum", SqlDbType.Decimal), new SqlParameter("@Price", SqlDbType.Decimal), new SqlParameter("@CreateUserID", SqlDbType.Int), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@ts", SqlDbType.DateTime), new SqlParameter("@modifyuser", SqlDbType.Int) }; parameters[0].Value = model.DisID; parameters[1].Value = model.CompID; parameters[2].Value = model.GoodsID; parameters[3].Value = model.IsSale; if (model.GoodsInfo != null) { parameters[4].Value = model.GoodsInfo; } else { parameters[4].Value = DBNull.Value; } if (model.BatchNO != null) { parameters[5].Value = model.BatchNO; } else { parameters[5].Value = DBNull.Value; } if (model.validDate != DateTime.MinValue) { parameters[6].Value = model.validDate; } else { parameters[6].Value = DBNull.Value; } parameters[7].Value = model.StockTotalNum; parameters[8].Value = model.StockUseNum; parameters[9].Value = model.StockNum; parameters[10].Value = model.MinAlertNum; parameters[11].Value = model.MaxAlertNum; parameters[12].Value = model.Price; parameters[13].Value = model.CreateUserID; parameters[14].Value = model.CreateDate; parameters[15].Value = model.ts; parameters[16].Value = model.modifyuser; if (Tran != null) { return(SqlHelper.GetInt(SqlHelper.GetSingle(strSql.ToString(), Tran, parameters))); } return(SqlHelper.GetInt(SqlHelper.GetSingle(SqlHelper.LocalSqlServer, strSql.ToString(), parameters))); }
/// <summary> /// Updates a TableColumnsUser into the data store based on the primitive properties. This can be used as the /// update method for an ObjectDataSource. /// </summary> /// <param name="iD">iD</param> /// <param name="tableColumnID">tableColumnID</param> /// <param name="userID">userID</param> /// <param name="sortOrder">sortOrder</param> /// <param name="isShown">isShown</param> /// <param name="serviceStatus">serviceStatus</param> /// <param name="serviceType">serviceType</param> /// <param name="helper">helper</param> internal static void UpdateTableColumnsUser(int @iD, int @tableColumnID, int @userID, int @sortOrder, bool @isShown, int @serviceStatus, int @serviceType, SqlHelper @helper) { string commandText = @" DECLARE @table TABLE( [ID] int, [TableColumnID] int, [UserID] int, [SortOrder] int, [IsShown] bit, [ServiceStatus] int, [ServiceType] int ); UPDATE [dbo].[TableColumnsUser] SET [TableColumnsUser].[TableColumnID] = @TableColumnID, [TableColumnsUser].[UserID] = @UserID, [TableColumnsUser].[SortOrder] = @SortOrder, [TableColumnsUser].[IsShown] = @IsShown, [TableColumnsUser].[ServiceStatus] = @ServiceStatus, [TableColumnsUser].[ServiceType] = @ServiceType output INSERTED.[ID], INSERTED.[TableColumnID], INSERTED.[UserID], INSERTED.[SortOrder], INSERTED.[IsShown], INSERTED.[ServiceStatus], INSERTED.[ServiceType] into @table WHERE [TableColumnsUser].[ID] = @ID SELECT [ID], [TableColumnID], [UserID], [SortOrder], [IsShown], [ServiceStatus], [ServiceType] FROM @table; "; System.Collections.Generic.List<SqlParameter> parameters = new System.Collections.Generic.List<SqlParameter>(); parameters.Add(new SqlParameter("@ID", EntityBase.GetDatabaseValue(@iD))); parameters.Add(new SqlParameter("@TableColumnID", EntityBase.GetDatabaseValue(@tableColumnID))); parameters.Add(new SqlParameter("@UserID", EntityBase.GetDatabaseValue(@userID))); parameters.Add(new SqlParameter("@SortOrder", EntityBase.GetDatabaseValue(@sortOrder))); parameters.Add(new SqlParameter("@IsShown", @isShown)); parameters.Add(new SqlParameter("@ServiceStatus", EntityBase.GetDatabaseValue(@serviceStatus))); parameters.Add(new SqlParameter("@ServiceType", EntityBase.GetDatabaseValue(@serviceType))); @helper.Execute(commandText, CommandType.Text, parameters); }
/// <summary> /// 年休假设置信息添加 /// </summary> /// <param name="YearHolidayM">YearHolidayM</param> /// <param name="StrYearHoliday">年休假设置信息</param> /// <returns>添加是否成功 false:失败,true:成功</returns> public static string AddYearHolidayInfoSet(YearHolidayModel YearHolidayM, string StrYearHoliday) { string[] strarray = null; string recorditems = ""; string[] inseritems = null; string ErrMsg = ""; try { strarray = StrYearHoliday.Split('|'); for (int i = 0; i < strarray.Length; i++) { StringBuilder StrYearHolidaySql = new StringBuilder(); recorditems = strarray[i]; inseritems = recorditems.Split(','); if (recorditems.Length != 0) { string EmployeeID = inseritems[0].ToString().Trim(); //员工ID string HolidayHours = inseritems[1].ToString().Trim(); //时长 string UserName = inseritems[2].ToString().Trim(); //姓名 if (YearHolidayIsExist(EmployeeID) == 0) //插入 { #region 添加SQL StrYearHolidaySql.AppendLine("INSERT INTO officedba.YearHoliday"); StrYearHolidaySql.AppendLine(" (CompanyCD "); StrYearHolidaySql.AppendLine(" ,EmployeeID "); StrYearHolidaySql.AppendLine(" ,HolidayHours "); StrYearHolidaySql.AppendLine(" ,ModifiedDate "); StrYearHolidaySql.AppendLine(" ,ModifiedUserID) "); StrYearHolidaySql.AppendLine("VALUES "); StrYearHolidaySql.AppendLine(" ('"+ YearHolidayM.CompanyCD + "' "); StrYearHolidaySql.AppendLine(" ,"+ Convert.ToInt32(EmployeeID) + " "); StrYearHolidaySql.AppendLine(" ,"+ Convert.ToDecimal(HolidayHours) + " "); StrYearHolidaySql.AppendLine(" ,'"+ YearHolidayM.ModifiedDate + "' "); StrYearHolidaySql.AppendLine(" ,'"+ YearHolidayM.ModifiedUserID + "') "); #endregion } else//更新 { #region 更新SQL StrYearHolidaySql.AppendLine("UPDATE officedba.YearHoliday"); StrYearHolidaySql.AppendLine(" SET CompanyCD='"+ YearHolidayM.CompanyCD + "' "); StrYearHolidaySql.AppendLine(" ,HolidayHours="+ Convert.ToDecimal(HolidayHours) + " "); StrYearHolidaySql.AppendLine(" ,ModifiedDate='"+ YearHolidayM.ModifiedDate + "' "); StrYearHolidaySql.AppendLine(" ,ModifiedUserID='"+ YearHolidayM.ModifiedUserID + "' "); StrYearHolidaySql.AppendLine(" WHERE EmployeeID="+ Convert.ToInt32(EmployeeID) + " "); #endregion } SqlHelper.ExecuteTransSql(StrYearHolidaySql.ToString()); if (SqlHelper.Result.OprateCount <= 0) { ErrMsg = UserName + ','; } } } return(ErrMsg); } catch (Exception ex) { return(ex.ToString()); } }
/// <summary> /// 获取人员 /// </summary> /// <returns>DataTable</returns> public static DataTable GetUserList() { string sql = "select a.ID,a.EmployeeName from officedba.EmployeeInfo a "; return(SqlHelper.ExecuteSql(sql)); }
public DataTable GetResource(string typeId, int pageSize, int pageIndex) { SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@pageSize", pageSize), new SqlParameter("@pageIndex", pageIndex), new SqlParameter("@ResourceTypeId", typeId) }; return(SqlHelper.ExecuteQuery(CommandType.StoredProcedure, "cpResource", commandParameters)); }
public int GetCount() { string str = "SELECT COUNT(1) FROM Res_Resource"; return(DBHelper.GetInt(SqlHelper.ExecuteScalar(CommandType.Text, str.ToString(), new SqlParameter[0]))); }
public DataTable GetAllResource() { string cmdText = "SELECT * FROM Res_Resource "; return(SqlHelper.ExecuteQuery(CommandType.Text, cmdText, new SqlParameter[0])); }
/// <summary> /// 任务调度平台根据发布的任务时间配置,定时回调运行方法 /// 开发人员的任务插件必须要重载并该方法 /// </summary> public override void Run() { runcount++; ConfigHelper.LoadConfig(this.AppConfig["BusinessMQManageConnectString"]); List <tb_partition_model> userdpartitions = new List <tb_partition_model>(); Dictionary <int, tb_datanode_model> datanodemodels = new Dictionary <int, tb_datanode_model>(); List <RegisterdConsumersModel> registeredconsumermodels = new List <RegisterdConsumersModel>(); List <tb_consumer_model> consumers = new List <tb_consumer_model>(); DateTime servertime = DateTime.Now; SqlHelper.ExcuteSql(this.AppConfig["BusinessMQManageConnectString"], (c) => { tb_partition_dal partitiondal = new tb_partition_dal(); userdpartitions = partitiondal.List(c, true); tb_datanode_dal datanodedal = new tb_datanode_dal(); var ms = datanodedal.List(c); foreach (var m in ms) { datanodemodels.Add(m.datanodepartition, m); } servertime = c.GetServerDate(); //获取当前注册的消费者 tb_consumer_dal consumerdal = new tb_consumer_dal(); registeredconsumermodels = consumerdal.GetRegisterdConsumers(c); consumers = consumerdal.GetAllList(c); }); //消费者端心跳停止,异常退出检测(超过1分钟) List <Exception> exps = new List <Exception>(); foreach (var c in consumers) { if ((servertime - c.lastheartbeat) > TimeSpan.FromMinutes(1)) { exps.Add(new Exception(string.Format("当前消费者tempid:{0},consumerclientid:{1}", c.tempid, c.consumerclientid))); } } Error(this.AppConfig["BusinessMQManageConnectString"], "消费者端心跳停止,异常退出检测(超过1分钟),若是异常停止,请手工清除消费者中断", exps); //消费者端长时间无消费,但是还有多余消息(超过10分钟未消费,但还有多余消息未消费) exps.Clear(); foreach (var c in registeredconsumermodels) { if ((servertime - c.consumerpartitionmodel.lastupdatetime) > TimeSpan.FromMinutes(10)) { var partitionidinfo = XXF.BaseService.MessageQuque.BusinessMQ.SystemRuntime.PartitionRuleHelper.GetPartitionIDInfo(c.consumerpartitionmodel.partitionid); var tablename = XXF.BaseService.MessageQuque.BusinessMQ.SystemRuntime.PartitionRuleHelper.GetTableName(partitionidinfo.TablePartition, servertime.Date); SqlHelper.ExcuteSql(this.GetDataNodeConnectString(datanodemodels[partitionidinfo.DataNodePartition]), (conn) => { tb_messagequeue_dal messagedal = new tb_messagequeue_dal(); messagedal.TableName = tablename; long maxmqid = messagedal.GetMaxID(conn); if (maxmqid > c.consumerpartitionmodel.lastmqid && (servertime - messagedal.GetIDCreateTime(conn, maxmqid).Value > TimeSpan.FromMinutes(10)))//还有消息未消费,且该消息的创建时间是10分钟前 { exps.Add(new Exception(string.Format("当前消费者tempid:{0},consumerclientid:{1},client:{2},clientname:{3}", c.consumermodel.tempid, c.consumermodel.consumerclientid, c.consumerclientmodel.client, c.consumermodel.clientname))); } }); } } Error(this.AppConfig["BusinessMQManageConnectString"], "消费者端长时间无消费,但是还有多余消息(超过已创建超过10分钟的消息未消费),可能是消费者处理逻辑异常", exps); //某个分区没有指定消费者(分区没有消费信息,或者分区消费最后消费时间超过1个小时无消费) exps.Clear(); if (runcount % (12 * 6) == 0) { foreach (var u in userdpartitions) { bool isfind = false; foreach (var c in registeredconsumermodels) { if (c.consumerpartitionmodel.partitionid == u.partitionid) { isfind = true; break; } } if (isfind == false) { SqlHelper.ExcuteSql(this.AppConfig["BusinessMQManageConnectString"], (c) => { tb_consumer_partition_dal dal = new tb_consumer_partition_dal(); var model = dal.GetByPartitionId(c, u.partitionid); if (model == null) { exps.Add(new Exception(string.Format("分区{0}未指定消费者", u.partitionid))); } //else if((servertime - model.lastupdatetime) > TimeSpan.FromHours(24)) // exps.Add(new Exception(string.Format("分区{0}消费者已注销,且有1天未消费", u.partitionid))); }); } } Error(this.AppConfig["BusinessMQManageConnectString"], "某个分区没有指定消费者(分区没有消费信息)", exps); } }
public static StyleSheet GetByName(string name) { try { int id = SqlHelper.ExecuteScalar <int>("SELECT id FROM umbracoNode WHERE text = @text AND nodeObjectType = @objType ", SqlHelper.CreateParameter("@text", name), SqlHelper.CreateParameter("@objType", StyleSheet.ModuleObjectType)); return(new StyleSheet(id)); } catch { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Hi.Model.DIS_GoodsStock model, SqlTransaction Tran) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [DIS_GoodsStock] set "); strSql.Append("[DisID]=@DisID,"); strSql.Append("[CompID]=@CompID,"); strSql.Append("[GoodsID]=@GoodsID,"); strSql.Append("[IsSale]=@IsSale,"); strSql.Append("[GoodsInfo]=@GoodsInfo,"); strSql.Append("[BatchNO]=@BatchNO,"); strSql.Append("[validDate]=@validDate,"); strSql.Append("[StockTotalNum]=@StockTotalNum,"); strSql.Append("[StockUseNum]=@StockUseNum,"); strSql.Append("[StockNum]=@StockNum,"); strSql.Append("[MinAlertNum]=@MinAlertNum,"); strSql.Append("[MaxAlertNum]=@MaxAlertNum,"); strSql.Append("[Price]=@Price,"); strSql.Append("[CreateUserID]=@CreateUserID,"); strSql.Append("[CreateDate]=@CreateDate,"); strSql.Append("[ts]=@ts,"); strSql.Append("[dr]=@dr,"); strSql.Append("[modifyuser]=@modifyuser"); strSql.Append(" where [ID]=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.BigInt), new SqlParameter("@DisID", SqlDbType.Int), new SqlParameter("@CompID", SqlDbType.Int), new SqlParameter("@GoodsID", SqlDbType.BigInt), new SqlParameter("@IsSale", SqlDbType.Int), new SqlParameter("@GoodsInfo", SqlDbType.VarChar, 200), new SqlParameter("@BatchNO", SqlDbType.VarChar, 100), new SqlParameter("@validDate", SqlDbType.DateTime), new SqlParameter("@StockTotalNum", SqlDbType.Decimal), new SqlParameter("@StockUseNum", SqlDbType.Decimal), new SqlParameter("@StockNum", SqlDbType.Decimal), new SqlParameter("@MinAlertNum", SqlDbType.Decimal), new SqlParameter("@MaxAlertNum", SqlDbType.Decimal), new SqlParameter("@Price", SqlDbType.Decimal), new SqlParameter("@CreateUserID", SqlDbType.Int), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@ts", SqlDbType.DateTime), new SqlParameter("@dr", SqlDbType.SmallInt), new SqlParameter("@modifyuser", SqlDbType.Int) }; parameters[0].Value = model.ID; parameters[1].Value = model.DisID; parameters[2].Value = model.CompID; parameters[3].Value = model.GoodsID; parameters[4].Value = model.IsSale; if (model.GoodsInfo != null) { parameters[5].Value = model.GoodsInfo; } else { parameters[5].Value = DBNull.Value; } if (model.BatchNO != null) { parameters[6].Value = model.BatchNO; } else { parameters[6].Value = DBNull.Value; } if (model.validDate != DateTime.MinValue) { parameters[7].Value = model.validDate; } else { parameters[7].Value = DBNull.Value; } parameters[8].Value = model.StockTotalNum; parameters[9].Value = model.StockUseNum; parameters[10].Value = model.StockNum; parameters[11].Value = model.MinAlertNum; parameters[12].Value = model.MaxAlertNum; parameters[13].Value = model.Price; parameters[14].Value = model.CreateUserID; parameters[15].Value = model.CreateDate; parameters[16].Value = model.ts; parameters[17].Value = model.dr; parameters[18].Value = model.modifyuser; if (Tran != null) { return(SqlHelper.ExecuteSql(strSql.ToString(), Tran, parameters) > 0); } return(SqlHelper.ExecuteSql(SqlHelper.LocalSqlServer, strSql.ToString(), parameters) > 0); }
public static StyleSheet MakeNew(BusinessLogic.User user, string Text, string FileName, string Content) { // Create the umbraco node var newNode = CMSNode.MakeNew(-1, ModuleObjectType, user.Id, 1, Text, Guid.NewGuid()); // Create the stylesheet data SqlHelper.ExecuteNonQuery(string.Format("insert into cmsStylesheet (nodeId, filename, content) values ('{0}','{1}',@content)", newNode.Id, FileName), SqlHelper.CreateParameter("@content", Content)); // save to file to avoid file coherency issues var newCss = new StyleSheet(newNode.Id, false, false); var e = new NewEventArgs(); newCss.OnNew(e); return(newCss); }
//绑定数据 public void GridViewBind() { SqlDataReader datar = SqlHelper.ExecuteReader("select a.*,b.mc,c.bm_mc,d.hys_mc from oa_hyqc a left outer JOIN hk_ZDYLX b on (a.hylx=b.id) left outer JOIN BM c on (a.zkbm=c.bm_id) left outer join oa_hys d on (a.zkdd=d.hys_id) where a.id='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "' and a.zt='送审中'"); if (datar.Read()) { hyzt.Text = datar["hyzt"].ToString(); hylx.Text = datar["mc"].ToString(); kssj.Text = datar["kssj"].ToString(); jssj.Text = datar["jssj"].ToString(); zkbm.Text = datar["bm_mc"].ToString(); zkdd.Text = datar["hys_mc"].ToString(); cxfw.Text = datar["cxfw"].ToString(); //将人员编码转化为名称 cjry.Text = (SqlHelper.ExecuteScalar("exec sp_IdToName '" + datar["cjry"] + "','1'") == System.DBNull.Value ? "" : (string)(SqlHelper.ExecuteScalar("exec sp_IdToName '" + datar["cjry"] + "','1'"))); fzr.Text = datar["zcr"].ToString(); jysm.Text = datar["jysm"].ToString(); savefj.Text = datar["hyzl"].ToString(); savefj.NavigateUrl = (datar["path"] == System.DBNull.Value ? "" : "../.." + datar["path"].ToString()) + datar["hyzl"].ToString(); vsdate.Text = datar["kssj"].ToString(); vedate.Text = datar["jssj"].ToString(); ycxx.Text = datar["fqr"].ToString(); ycdd.Text = datar["zkdd"].ToString(); datar.Close(); } else { datar.Close(); mydb.Alert_Close("此会议已审批完成!"); } if (!string.IsNullOrEmpty(savefj.Text)) { savefj.Text = "下载会议资料"; } }
public static bool DeleteBusinessKeywordsConfig(int id) { const string sql = @"DELETE FROM Configuration.dbo.BusinessKeywordsConfig WHERE Id=@Id"; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, new SqlParameter("@Id", id)) > 0); }
public override void delete() { var e = new DeleteEventArgs(); FireBeforeDelete(e); if (!e.Cancel) { File.Delete(IOHelper.MapPath(String.Format("{0}/{1}.css", SystemDirectories.Css, this.Text))); foreach (var p in Properties.Where(p => p != null)) { p.delete(); } SqlHelper.ExecuteNonQuery("delete from cmsStylesheet where nodeId = @nodeId", SqlHelper.CreateParameter("@nodeId", this.Id)); base.delete(); FireAfterDelete(e); } }
public static bool ConcelConfirm(string ID, string FromType, string OrderNo, List<ProductModel> ProductMList, List<ProductModel> ProductMStorList, out string Reason) { try { Reason = string.Empty; //不可以确认返回false if (!PurchaseOrderDBHelper.CanConcel(ID, out Reason)) return false; ArrayList lstConcelConfirm = new ArrayList(); //更新主表 SqlCommand ConcelPri = PurchaseOrderDBHelper.ConcelConfirm(ID); lstConcelConfirm.Add(ConcelPri); //更新分仓存量表 if (ProductMStorList != null) { foreach (ProductModel ProductM in ProductMStorList) { SqlCommand comm = PurchaseOrderDBHelper.WriteStorgeDecr(ProductM); lstConcelConfirm.Add(comm); } } if (ProductMList != null) { if (FromType == "2") {//回写采购计划 foreach (ProductModel ProductM in ProductMList) { SqlCommand comm = PurchaseOrderDBHelper.WritePurPlanDecr(ProductM); lstConcelConfirm.Add(comm); } } else if (FromType == "4") {//回写采购合同 foreach (ProductModel ProductM in ProductMList) { SqlCommand comm = PurchaseOrderDBHelper.WritePurContDecr(ProductM); lstConcelConfirm.Add(comm); } } } //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //撤销审批 string CompanyCD = userInfo.CompanyCD; string BillTypeFlag = ConstUtil.CODING_RULE_PURCHASE; string BillTypeCode = ConstUtil.CODING_RULE_PURCHASE_ORDER; string strUserID = userInfo.UserID; ; DataTable dt = FlowDBHelper.GetFlowInstanceInfo(CompanyCD, Convert.ToInt32(BillTypeFlag), Convert.ToInt32(BillTypeCode), Convert.ToInt32(ID)); if (dt.Rows.Count > 0) { string FlowInstanceID = dt.Rows[0]["FlowInstanceID"].ToString(); string FlowStatus = dt.Rows[0]["FlowStatus"].ToString(); string FlowNo = dt.Rows[0]["FlowNo"].ToString(); lstConcelConfirm.Add(FlowDBHelper.CancelConfirmHis(CompanyCD, FlowInstanceID, FlowNo, BillTypeFlag, BillTypeCode, strUserID)); lstConcelConfirm.Add(FlowDBHelper.CancelConfirmTsk(CompanyCD, FlowInstanceID, strUserID)); lstConcelConfirm.Add(FlowDBHelper.CancelConfirmIns(CompanyCD, FlowNo, BillTypeFlag, BillTypeCode, ID, strUserID)); } //定义返回变量 bool isSucc = false; /* * 定义日志内容变量 * 增删改相关的日志,需要输出操作日志,该类型日志插入到数据库 * 其他的 如出现异常时,需要输出系统日志,该类型日志保存到日志文件 */ //执行插入操作 try { isSucc = SqlHelper.ExecuteTransWithArrayList(lstConcelConfirm); } catch (Exception ex) { //输出日志 WriteSystemLog(userInfo, ex); } //定义变量 string remark; //成功时 if (isSucc) { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } LogInfoModel logModel = InitLogInfo(OrderNo); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 logModel.Element = ConstUtil.LOG_PROCESS_UNCONFIRM; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); return isSucc; } catch (Exception ex) { throw ex; } }
public ViewResult Index(string txtCode, string txtName, string txtCardCode, int?CardTypeId, string txtPhone, string txtLicensePlates, string txtOption) { var q = CustomerRepository.GetAllvwCustomer().Where(x => x.BranchId == Helpers.Common.CurrentUser.BranchId); if (!string.IsNullOrEmpty(txtCardCode)) { q = q.Where(x => x.CardCode == txtCardCode); } if (!string.IsNullOrEmpty(txtCode)) { q = q.Where(x => x.Code.Contains(txtCode)); } if (!string.IsNullOrEmpty(txtName)) { q = q.Where(x => x.Name.Contains(txtName)); } if (!string.IsNullOrEmpty(txtPhone)) { q = q.Where(x => x.Phone.Contains(txtPhone)); } //if (CardTypeId != null) //{ // q = q.Where(x => x.MemberCardTypeId == CardTypeId); //} if (!string.IsNullOrEmpty(txtLicensePlates)) { q = SqlHelper.QuerySP <vwCustomer>("spSale_GetCustomerByPlate", new { Plate = txtLicensePlates }).AsQueryable(); } if (!string.IsNullOrEmpty(txtOption)) { bool check = txtOption == "YES" ? true: false; if (check) { q = q.Where(x => x.MemberCardId != null); } else { q = q.Where(x => x.MemberCardId == null); } } IQueryable <CustomerViewModel> model = q.Select(item => new CustomerViewModel { Id = item.Id, CreatedUserId = item.CreatedUserId, CreatedDate = item.CreatedDate, ModifiedUserId = item.ModifiedUserId, ModifiedDate = item.ModifiedDate, Code = item.Code, Name = item.Name, Phone = item.Phone, Address = item.Address, WardName = item.WardName, ProvinceName = item.ProvinceName, DistrictName = item.DistrictName, Point = item.Point, MemberCardTypeName = item.MemberCardTypeName, CardCode = item.CardCode, EndDateProductInvoice = item.EndDateProductInvoice }).OrderByDescending(m => m.ModifiedDate); ViewBag.SuccessMessage = TempData["SuccessMessage"]; ViewBag.FailedMessage = TempData["FailedMessage"]; ViewBag.AlertMessage = TempData["AlertMessage"]; return(View(model)); }
public static bool DeletePurchaseOrder(string IDs, string OrderNos) { try { ArrayList lstDelete = new ArrayList(); SqlCommand DelPri = PurchaseOrderDBHelper.DeletePurchaseOrder(IDs); lstDelete.Add(DelPri); SqlCommand DelDtl = PurchaseOrderDBHelper.DeletePurchaseOrderDetail(OrderNos); lstDelete.Add(DelDtl); //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //定义返回变量 bool isSucc = false; /* * 定义日志内容变量 * 增删改相关的日志,需要输出操作日志,该类型日志插入到数据库 * 其他的 如出现异常时,需要输出系统日志,该类型日志保存到日志文件 */ //执行删除操作 try { isSucc = SqlHelper.ExecuteTransWithArrayList(lstDelete); } catch (Exception ex) { //输出日志 WriteSystemLog(userInfo, ex); } //定义变量 string remark; //成功时 if (isSucc) { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } //获取删除的编号列表 string[] noList = OrderNos.Split(','); //遍历所有编号,登陆操作日志 for (int i = 0; i < noList.Length; i++) { //获取编号 string no = noList[i]; //替换两边的 ' no = no.Replace("'", string.Empty); //操作日志 LogInfoModel logModel = InitLogInfo(no); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 logModel.Element = ConstUtil.LOG_PROCESS_DELETE; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); } return isSucc; } catch (Exception ex) { throw ex; } }
static void Main() { var connectionString = @"Data Source=.\SqlExpress;Initial Catalog=nservicebus;Integrated Security=True;Max Pool Size=100;Min Pool Size=10"; Console.Title = "Samples.ServiceControl.SqlServerTransportAdapter.Shipping"; var endpointConfiguration = new BusConfiguration(); endpointConfiguration.EndpointName("Samples.ServiceControl.SqlServerTransportAdapter.Shipping"); var transport = endpointConfiguration.UseTransport <SqlServerTransport>(); transport.ConnectionString(connectionString); SqlHelper.EnsureDatabaseExists(connectionString); SqlHelper.CreateSchema(connectionString, "shipping"); SqlHelper.CreateSchema(connectionString, "adapter"); #region ShippingSchema //Use custom schema shipping for this endpoint transport.DefaultSchema("shipping"); transport.UseSpecificConnectionInformation( //Configure schema for sales endpoint so that the subscribe message is sent to the correct address EndpointConnectionInfo.For("Samples.ServiceControl.SqlServerTransportAdapter.Sales").UseSchema("sales"), //Configure schemas for ServiceControl queues to point to the adapter EndpointConnectionInfo.For("audit").UseSchema("adapter"), EndpointConnectionInfo.For("error").UseSchema("adapter"), EndpointConnectionInfo.For("Particular.ServiceControl").UseSchema("adapter") ); #endregion endpointConfiguration.UsePersistence <InMemoryPersistence>(); var chaos = new ChaosGenerator(); endpointConfiguration.RegisterComponents( registration: components => { components.ConfigureComponent(() => chaos, DependencyLifecycle.SingleInstance); }); endpointConfiguration.DisableFeature <SecondLevelRetries>(); var conventions = endpointConfiguration.Conventions(); conventions.DefiningEventsAs(t => t == typeof(OrderAccepted) || t == typeof(OrderShipped)); endpointConfiguration.SendHeartbeatTo("Particular.ServiceControl"); endpointConfiguration.EnableInstallers(); using (var endpointInstance = Bus.Create(endpointConfiguration).Start()) { Console.WriteLine("Press enter to exit"); Console.WriteLine("Press 'f' to toggle simulating of message processing failure"); while (true) { var key = Console.ReadKey(); Console.WriteLine(); if (key.Key == ConsoleKey.Enter) { break; } var lowerInvariant = char.ToLowerInvariant(key.KeyChar); if (lowerInvariant == 'f') { chaos.IsFailing = !chaos.IsFailing; Console.WriteLine($"Failure simulation is now turned {(chaos.IsFailing ? "on" : "off")}"); } } } }
public static bool InsertPurchaseOrder(PurchaseOrderModel PurchaseOrderM, List<PurchaseOrderDetailModel> PurchaseOrderDetailMList, out int IndexIDentity, out string Reason, Hashtable htExtAttr) { try { IndexIDentity = 0; //判断引用源单数量有没有超过,超过了就不让保存 if (!PurchaseOrderDBHelper.CanSave(PurchaseOrderDetailMList, out Reason)) return false; ArrayList lstAdd = new ArrayList(); //插入主表 SqlCommand AddPri = PurchaseOrderDBHelper.InsertPurchaseOrder(PurchaseOrderM); lstAdd.Add(AddPri); string OrderNo = PurchaseOrderM.OrderNo; //插入明细 foreach (PurchaseOrderDetailModel PurchaseOrderDetailM in PurchaseOrderDetailMList) { SqlCommand AddDetail = PurchaseOrderDBHelper.InsertPurchaseOrderDetail(PurchaseOrderDetailM, OrderNo); lstAdd.Add(AddDetail); } #region 拓展属性 SqlCommand cmd = new SqlCommand(); GetExtAttrCmd(PurchaseOrderM, htExtAttr, cmd); if (htExtAttr.Count > 0) lstAdd.Add(cmd); #endregion //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //定义返回变量 bool isSucc = false; /* * 定义日志内容变量 * 增删改相关的日志,需要输出操作日志,该类型日志插入到数据库 * 其他的 如出现异常时,需要输出系统日志,该类型日志保存到日志文件 */ //执行插入操作 try { isSucc = SqlHelper.ExecuteTransWithArrayList(lstAdd); } catch (Exception ex) { //输出日志 WriteSystemLog(userInfo, ex); } //定义变量 string remark; //成功时 if (isSucc) { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; IndexIDentity = int.Parse(((SqlCommand)AddPri).Parameters["@IndexID"].Value.ToString()); } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; IndexIDentity = 0; } LogInfoModel logModel = InitLogInfo(OrderNo); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 logModel.Element = ConstUtil.LOG_PROCESS_INSERT; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); return isSucc; } catch (Exception ex) { throw ex; } }
public static bool ConfirmPuechaseOrder(string CompanyCD, string ID, string FromType, string OrderNo, out string Reason, List<ProductModel> ProductMList, List<ProductModel> ProductMStorList) { try { if (!PurchaseOrderDBHelper.CanConfirm(CompanyCD, OrderNo, int.Parse(ID), FromType, out Reason)) return false; ArrayList lstConfirm = new ArrayList(); //写确认人,确认时间,单据状态 lstConfirm.Add(PurchaseOrderDBHelper.ConfirmPurchaseOrder(ID)); //回写合同表 if (FromType == "4") { foreach (ProductModel ProductM in ProductMList) { lstConfirm.Add(PurchaseOrderDBHelper.WritePurContract(ProductM)); } } else if (FromType == "2") {//回写计划表 foreach (ProductModel ProductM in ProductMList) { lstConfirm.Add(PurchaseOrderDBHelper.WritePurPlanConfirm(ProductM)); } } //回写库存分仓存量表 foreach (ProductModel ProductM in ProductMStorList) { lstConfirm.Add(PurchaseOrderDBHelper.WriteStorge(ProductM)); } //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //定义返回变量 bool isSucc = false; /* * 定义日志内容变量 * 增删改相关的日志,需要输出操作日志,该类型日志插入到数据库 * 其他的 如出现异常时,需要输出系统日志,该类型日志保存到日志文件 */ //执行插入操作 try { isSucc = SqlHelper.ExecuteTransWithArrayList(lstConfirm); } catch (Exception ex) { //输出日志 WriteSystemLog(userInfo, ex); } //定义变量 string remark; //成功时 if (isSucc) { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } LogInfoModel logModel = InitLogInfo(OrderNo); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 logModel.Element = ConstUtil.LOG_PROCESS_CONFIRM; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); return isSucc; } catch (Exception ex) { throw ex; } }
public override IDataReader Email_GetAll() { return(SqlHelper.ExecuteReader(ConnectionString, GetFullyQualifiedName("Email_GetAll"))); }
/// <summary> /// 更新采购订单 /// </summary> /// <param name="PurchaseOrderM">主表model</param> /// <param name="PurchaseOrderDetailMList">明细表modellist</param> /// <param name="ProductMStorList">用于回写库存的物品modellist</param> /// <param name="ProductMList">用于回写计划或是合同的物品modellist</param> /// <returns>DataTable</returns> public static bool UpdatePurchaseOrder(PurchaseOrderModel PurchaseOrderM, List<PurchaseOrderDetailModel> PurchaseOrderDetailMList , List<ProductModel> ProductMStorList, List<ProductModel> ProductMList, out string Reason, Hashtable htExtAttr) { try { //判断引用源单数量有没有超过,超过了就不让保存 if (!PurchaseOrderDBHelper.CanSave(PurchaseOrderDetailMList, out Reason)) return false; //判断该单据有没有确认 //判断该单据是不是可以确认,包括引用的源单数量是不是合法,有没有到达库存报警上限 ArrayList lstUpdate = new ArrayList(); //更新主表 SqlCommand UpdatePri = PurchaseOrderDBHelper.UpdatePurchaseOrder(PurchaseOrderM); lstUpdate.Add(UpdatePri); #region 拓展属性 SqlCommand cmd = new SqlCommand(); GetExtAttrCmd(PurchaseOrderM, htExtAttr, cmd); if (htExtAttr.Count > 0) lstUpdate.Add(cmd); #endregion string OrderNo = PurchaseOrderM.OrderNo; //删除明细 SqlCommand DeleteDetail = PurchaseOrderDBHelper.DeletePurchaseOrderDetailSingle(OrderNo); lstUpdate.Add(DeleteDetail); //插入明细 foreach (PurchaseOrderDetailModel PurchaseOrderDetailM in PurchaseOrderDetailMList) { SqlCommand AddDetail = PurchaseOrderDBHelper.InsertPurchaseOrderDetail(PurchaseOrderDetailM, OrderNo); lstUpdate.Add(AddDetail); } //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //定义返回变量 bool isSucc = false; /* * 定义日志内容变量 * 增删改相关的日志,需要输出操作日志,该类型日志插入到数据库 * 其他的 如出现异常时,需要输出系统日志,该类型日志保存到日志文件 */ //执行插入操作 try { isSucc = SqlHelper.ExecuteTransWithArrayList(lstUpdate); } catch (Exception ex) { //输出日志 WriteSystemLog(userInfo, ex); } //定义变量 string remark; //成功时 if (isSucc) { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } LogInfoModel logModel = InitLogInfo(OrderNo); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 logModel.Element = ConstUtil.LOG_PROCESS_UPDATE; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); return isSucc; } catch (Exception ex) { throw ex; } }
public override IDataReader GetEmailTemplateId(int EmailTemplateId) { return(SqlHelper.ExecuteReader(ConnectionString, GetFullyQualifiedName("GetEmailTemplate"), EmailTemplateId)); }
/// <summary> /// Persists the object. /// </summary> public virtual void Persist(CitizenshipResidencyType persistObject, SqlTransaction sqlTrans) { // create local variable array for the sql parameters SqlParameterHash sqlparams = null; // Create a local variable for the connection SqlConnection cnn = null; // Use the parameter overload or create a new instance if (sqlTrans == null) cnn = new SqlConnection(CitizenshipResidencyType.GetConnectionString()); try { // discover the parameters if (persistObject.Persisted) sqlparams = SqlHelperParameterCache.GetSpParameterSet(CitizenshipResidencyType.GetConnectionString(), "gsp_UpdateCitizenshipResidencyType"); else sqlparams = SqlHelperParameterCache.GetSpParameterSet(CitizenshipResidencyType.GetConnectionString(), "gsp_CreateCitizenshipResidencyType"); // Store the parameter for the Name attribute. sqlparams["@name"].Value = persistObject.Name; // Store the parameter for the EnumeratedName attribute. sqlparams["@enumeratedName"].Value = persistObject.EnumeratedName; // Store the parameter for the Description attribute. if (!persistObject.DescriptionIsNull) sqlparams["@description"].Value = persistObject.Description; // Store the parameter for the Id attribute. sqlparams["@id"].Value = persistObject.Id; if (!persistObject.Persisted) { // store the create only (historical fixed) values } else { // store the update only (historical changeable) values } if (sqlTrans == null) { // Process using the isolated connection using (cnn) { // open the connection cnn.Open(); if (!persistObject.Persisted) { SqlHelper.ExecuteNonQuery(cnn, CommandType.StoredProcedure, "gsp_CreateCitizenshipResidencyType", sqlparams); } else { SqlHelper.ExecuteNonQuery(cnn, CommandType.StoredProcedure, "gsp_UpdateCitizenshipResidencyType", sqlparams); } // close the connection after usage cnn.Close(); } // nullify the connection var cnn = null; } else { // Process using the shared transaction if (!persistObject.Persisted) { SqlHelper.ExecuteNonQuery(sqlTrans, CommandType.StoredProcedure, "gsp_CreateCitizenshipResidencyType", sqlparams); } else { SqlHelper.ExecuteNonQuery(sqlTrans, CommandType.StoredProcedure, "gsp_UpdateCitizenshipResidencyType", sqlparams); } } } catch (SqlException sqlex) { throw sqlex; } }
public override void EmailTemplate_Update(int Id, string subject, int typeEmail, string content) { SqlHelper.ExecuteScalar(ConnectionString, GetFullyQualifiedName("EmailTemplate_Update"), Id, subject, typeEmail, content); }
public override IDataReader GetEmailInfo(int Id) { return(SqlHelper.ExecuteReader(ConnectionString, GetFullyQualifiedName("GetEmailInfo"), Id)); }
/// ----------------------------------------------------------------------------- /// <summary> /// Obtiene un registro de la tabla T304_SUBNODO, /// y devuelve una instancia u objeto del tipo SUBNODO /// </summary> /// <returns></returns> /// <history> /// Creado por [sqladmin] 10/06/2008 12:52:13 /// </history> /// ----------------------------------------------------------------------------- public static SUBNODO Select(SqlTransaction tr, int t304_idsubnodo) { SUBNODO o = new SUBNODO(); SqlParameter[] aParam = new SqlParameter[1]; aParam[0] = new SqlParameter("@t304_idsubnodo", SqlDbType.Int, 4); aParam[0].Value = t304_idsubnodo; SqlDataReader dr; if (tr == null) { dr = SqlHelper.ExecuteSqlDataReader("SUP_SUBNODO_S", aParam); } else { dr = SqlHelper.ExecuteSqlDataReaderTransaccion(tr, "SUP_SUBNODO_S", aParam); } if (dr.Read()) { if (dr["t304_idsubnodo"] != DBNull.Value) { o.t304_idsubnodo = int.Parse(dr["t304_idsubnodo"].ToString()); } if (dr["t304_denominacion"] != DBNull.Value) { o.t304_denominacion = (string)dr["t304_denominacion"]; } if (dr["t303_idnodo"] != DBNull.Value) { o.t303_idnodo = int.Parse(dr["t303_idnodo"].ToString()); } if (dr["t304_orden"] != DBNull.Value) { o.t304_orden = int.Parse(dr["t304_orden"].ToString()); } if (dr["t304_estado"] != DBNull.Value) { o.t304_estado = (bool)dr["t304_estado"]; } if (dr["t304_maniobra"] != DBNull.Value) { o.t304_maniobra = byte.Parse(dr["t304_maniobra"].ToString()); } if (dr["t314_idusuario_responsable"] != DBNull.Value) { o.t314_idusuario_responsable = int.Parse(dr["t314_idusuario_responsable"].ToString()); } if (dr["t313_idempresa"] != DBNull.Value) { o.t313_idempresa = int.Parse(dr["t313_idempresa"].ToString()); } if (dr["t313_denominacion"] != DBNull.Value) { o.t313_denominacion = (string)dr["t313_denominacion"]; } } else { throw (new NullReferenceException("No se ha obtenido ningun dato de SUBNODO")); } dr.Close(); dr.Dispose(); return(o); }
public override IDataReader EmailTemplate_Filter(int pageIndex, int pageSize) { return(SqlHelper.ExecuteReader(ConnectionString, GetFullyQualifiedName("EmailTemplate_GetAll"), pageIndex, pageSize)); }
//proceso de estado public static DataTable DtoListarEstado() { return(SqlHelper.ExecuteDataTable(conexion, "Listar_Estado")); }
public override void Visit(SqlFunctionCall node) { switch (node.FunctionType) { case SqlFunctionType.PadLeft: case SqlFunctionType.PadRight: SqlHelper.GenericPad(node).AcceptVisitor(this); return; case SqlFunctionType.DateTimeOffsetAddYears: case SqlFunctionType.DateTimeAddYears: DateTimeAddComponent(node.Arguments[0], node.Arguments[1], true).AcceptVisitor(this); return; case SqlFunctionType.DateTimeOffsetAddMonths: case SqlFunctionType.DateTimeAddMonths: DateTimeAddComponent(node.Arguments[0], node.Arguments[1], false).AcceptVisitor(this); return; case SqlFunctionType.IntervalConstruct: IntervalConstruct(node.Arguments[0]).AcceptVisitor(this); return; case SqlFunctionType.DateTimeConstruct: DateTimeConstruct(node.Arguments[0], node.Arguments[1], node.Arguments[2]).AcceptVisitor(this); return; case SqlFunctionType.IntervalAbs: SqlHelper.IntervalAbs(node.Arguments[0]).AcceptVisitor(this); return; case SqlFunctionType.IntervalToMilliseconds: SqlHelper.IntervalToMilliseconds(node.Arguments[0]).AcceptVisitor(this); return; case SqlFunctionType.IntervalToNanoseconds: SqlHelper.IntervalToNanoseconds(node.Arguments[0]).AcceptVisitor(this); return; case SqlFunctionType.Position: Position(node.Arguments[0], node.Arguments[1]).AcceptVisitor(this); return; case SqlFunctionType.CharLength: SqlDml.Coalesce(SqlDml.FunctionCall("LENGTH", node.Arguments[0]), 0).AcceptVisitor(this); return; case SqlFunctionType.DateTimeToStringIso: DateTimeToStringIso(node.Arguments[0]).AcceptVisitor(this); return; case SqlFunctionType.DateTimeOffsetConstruct: DateTimeOffsetConstruct(node.Arguments[0], node.Arguments[1]).AcceptVisitor(this); return; case SqlFunctionType.DateTimeOffsetTimeOfDay: DateTimeOffsetTimeOfDay(node.Arguments[0]).AcceptVisitor(this); return; case SqlFunctionType.DateTimeOffsetToLocalTime: DateTimeOffsetToLocalTime(node.Arguments[0]).AcceptVisitor(this); return; case SqlFunctionType.DateTimeToDateTimeOffset: DateTimeToDateTimeOffset(node.Arguments[0]).AcceptVisitor(this); return; case SqlFunctionType.DateTimeOffsetToUtcTime: DateTimeOffsetToUtcTime(node.Arguments[0]).AcceptVisitor(this); return; default: base.Visit(node); return; } }