protected string clearLine() { bool result = false; string line = Request.Form["line"]; if (!string.IsNullOrEmpty(line) && line != "all") { using (DB db = new DB()) { List<DowntimeData> list = (from o in db.DowntimeDataSet where o.Client == "admin" && o.Line == line select o).ToList(); if (list.Count() > 0) { foreach (DowntimeData dt in list) { db.DeleteObject(dt); } } result = db.SaveChanges() > 0; } } return result.ToString(); }
protected int DoUpdate(int finished) { int i = 0; using (SqlConnection conn = new DB().GetConnection()) { string sql = "Update Shows set Title=@Title,Abs=@Abs,Catalog=@Catalog,CatalogID=@CatalogID,CoverPhotoURL=@CoverPhotoURL,CDT=@CDT,Status=@Status,Orders=@Orders,Finished=@Finished where ID=@ID"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@Title", TitleTB.Text); cmd.Parameters.AddWithValue("@Abs", AbsTextBox.Text); cmd.Parameters.AddWithValue("@Catalog", CatalogsDDL.SelectedItem.Text); cmd.Parameters.AddWithValue("@CatalogID", CatalogsDDL.SelectedValue); cmd.Parameters.AddWithValue("@CoverPhotoURL", CoverPhoto.ImageUrl); cmd.Parameters.AddWithValue("@CDT", CDT_TextBox.Text); // RoleID={1,Administrator},{2,Editor},{3,Contributor},{4,Author} int RoleID = Convert.ToInt16(Session["RoleID"].ToString()); if (RoleID > 2) { cmd.Parameters.AddWithValue("@Status", 0); //状态:新投稿/待审核=0,审核已过=1,审核未过=2 } else { cmd.Parameters.AddWithValue("@Status", 1); //状态:新投稿/待审核=0,审核已过=1,审核未过=2 } cmd.Parameters.AddWithValue("@Orders", Orders.Text); cmd.Parameters.AddWithValue("@Finished", finished); cmd.Parameters.AddWithValue("@ID",IDLabel.Text); conn.Open(); i = cmd.ExecuteNonQuery(); } return i; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int RoleID = Convert.ToInt16(Session["RoleID"].ToString()); if (Session["RoleID"] == null || Session["UserID"] == null) { Util.ShowMessage("用户登录超时,请重新登录!", "Login2.aspx"); } else if (RoleID > 1) { Util.ShowMessage("您没有访问该页面的权限!", "Login2.aspx"); } else { UserName.Focus(); using (SqlConnection conn = new DB().GetConnection()) { string sql1 = "select * from Roles order by ID asc"; SqlCommand cmd1 = new SqlCommand(sql1, conn); conn.Open(); SqlDataReader rd1 = cmd1.ExecuteReader(); Role.DataSource = rd1; Role.DataTextField = "RoleName"; Role.DataValueField = "ID"; Role.DataBind(); rd1.Close(); } } } }
public string GetJobName(object jobskyerID) //把jobskyerID转化为jobName输出 { DB db = new DB(); SqlDataReader dr = db.reDr("SELECT jobName FROM jobskyer WHERE jobskyerID='" + jobskyerID + "'"); dr.Read(); return dr.GetValue(0).ToString(); }
//在数据表Resources插入一条记录操作 protected bool InsertDataBase() { bool result = false; using (SqlConnection conn = new DB().GetConnection()) { //向resources插入一条记录操作 StringBuilder sb = new StringBuilder("Insert into Resources (ResourceName,FileName,FilePath,FileSizeInKB,FileType,Extentsion,FolderID,FolderName,UserID,CDT,Status,UserName)"); sb.Append(" values(@ResourceName,@FileName,@FilePath,@FileSize,@FileType,@Extentsion,@FolderID,@FolderName,@UserID,@CDT,@Status,@UserName)"); SqlCommand cmd = new SqlCommand(sb.ToString(), conn); //cmd.Parameters.AddWithValue("@ResourceName", TextBox1.Text); cmd.Parameters.AddWithValue("@ResourceName", TextBox1.Text.Trim()); cmd.Parameters.AddWithValue("@FileName", FN.Text); cmd.Parameters.AddWithValue("@FilePath", FP.Text); cmd.Parameters.AddWithValue("@FileSize", FS.Text); cmd.Parameters.AddWithValue("@FileType", ResourceTypeLabel.Text); cmd.Parameters.AddWithValue("@Extentsion", FET.Text); cmd.Parameters.AddWithValue("@FolderID", 0); cmd.Parameters.AddWithValue("@FolderName", ""); cmd.Parameters.AddWithValue("@UserID", Session["UserID"].ToString()); cmd.Parameters.AddWithValue("@UserName", Session["UserName"].ToString()); cmd.Parameters.AddWithValue("@CDT", DateTime.Now); cmd.Parameters.AddWithValue("@Status", 0); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); //插入成功 result = true; } return result; }
protected void Button1_Click(object sender, EventArgs e) { int i = 0; using (SqlConnection conn = new DB().GetConnection()) { SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "Delete from SubMenu where ID in (" + IDSLabel.Text + ") "; conn.Open(); i = cmd.ExecuteNonQuery(); cmd.Dispose(); cmd.CommandText = "select * from SubMenu where ID in (" + IDSLabel.Text + ") order by ID desc"; SqlDataReader rd = cmd.ExecuteReader(); GridView1.DataSource = rd; GridView1.DataBind(); rd.Close(); conn.Close(); } if (i > 0) { ResultLabel.Text = "成功删除!"; ResultLabel.ForeColor = System.Drawing.Color.Green; } else { ResultLabel.Text = "操作失败,请重试!"; ResultLabel.ForeColor = System.Drawing.Color.Red; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["username"] == null) { Response.Write("<script>alert('用户登录超时,请重新登录。');location='../Default.aspx'</script>"); return; } DB db=new DB(); if (teacherName.Text == "") { this.GridView1.Visible =false; this.GridView2.Visible = true; } else { this.GridView1.Visible = true; this.GridView2.Visible = false; } }
/** * Fetches info needed from the database. */ private RevisionWorkInfo getWorkInfo(DB db, int revisionWorkID, int workID) { using (var cmd = db.CreateCommand ()) { cmd.CommandText = @" SELECT revision.revision, lane.id, lane.repository, lane.lane FROM revisionwork INNER JOIN revision ON revision.id = revisionwork.revision_id INNER JOIN lane ON lane.id = revision.lane_id WHERE revisionwork.id = @rwID; SELECT command.command FROM work INNER JOIN command ON command.id = work.command_id WHERE work.id = @wID "; DB.CreateParameter (cmd, "rwID", revisionWorkID); DB.CreateParameter (cmd, "wID", workID); using (var reader = cmd.ExecuteReader ()) { RevisionWorkInfo info; reader.Read (); info.hash = reader.GetString (0); info.laneID = reader.GetInt32 (1); info.repoURL = reader.GetString (2); info.laneName = reader.GetString (3); reader.NextResult (); reader.Read (); info.command = reader.GetString (0); return info; } } }
// 判断fileextension是否合法 protected bool CheckExtension(string extension) { bool result = false; // 如果Dictionary的键值数<1,即没有元素,则先读取数据表 if (ResourceTypes.Keys.Count < 1) { using (SqlConnection conn = new DB().GetConnection()) { SqlDataReader rd; SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "select * from ResourceTypes"; conn.Open(); rd = cmd.ExecuteReader(); while (rd.Read()) { ResourceTypes.Add(rd["Extension"].ToString(), rd["TypeName"].ToString()); } rd.Close(); conn.Close(); } } // 判断是否含有指定的后缀名 if (ResourceTypes.ContainsKey(extension)) { result = true; ResourceTypeLabel.Text = ResourceTypes[extension]; } return result; }
public bool Save(DB.Stru.福利中心.老人费用退费管理 stru) { string strID = Orm.Save(stru); stru.ID = strID; return ! String.IsNullOrEmpty(strID); }
private void Get_Attendence_Info() { try { DB db2 = new DB("Attendence"); db2.SelectedColumns.Add("*"); db2.AddCondition("Att_id", Attendence_Id); DataRow DR = db2.SelectRow(); Employees_CB.SelectedValue = DR["att_emp_id"]; Date_DTP.Value = DateTime.Parse(DR["att_date"].ToString()); Attend_DTP.Value = new DateTime(TimeSpan.Parse(DR["att_attend"].ToString()).Ticks); Leave_DTP.Value = DR["att_leave"].ToString() != "" ? new DateTime(TimeSpan.Parse(DR["att_leave"].ToString()).Ticks) : Leave_DTP.Value; } catch { } }
public bool Update_DutyTime()///如果选择了安排过值班的人,就更新值班安排数据 { DB db = new DB(); string dutyInTime = chooseWeekday.SelectedValue + chooseSignInTime.SelectedValue; string dutyOutTime = chooseWeekday.SelectedValue + chooseSignOutTime.SelectedValue; string str = "UPDATE dutyTimeTable SET dutyInTime=@dutyInTime,dutyOutTime=@dutyOutTime WHERE jobskyerID=@jobskyerID"; SqlConnection con = new SqlConnection(); con = db.GetCon(); SqlCommand com = new SqlCommand(str, con); com.Parameters.Add("@dutyInTime", SqlDbType.DateTime, 0).Value = dutyInTime; com.Parameters.Add("@dutyOutTime", SqlDbType.DateTime, 0).Value = dutyOutTime; com.Parameters.Add("@jobskyerID", SqlDbType.DateTime, 0).Value = chooseName.SelectedValue; try { com.ExecuteNonQuery(); Sign_Result.Text = "更新值班成功!"; } catch (Exception ex) { Sign_Result.Text = "更新值班失败!"; return false; } finally { com.Dispose(); con.Close(); } return true; }
public int year(string student_ID) { // //获取学生毕业学年 // DB db = new DB(); string selec = "select * from student where student_ID='" + student_ID + "'"; DataSet ds = db.Select(selec, db.DBconn()); int year; try { //如果读取到数据并装载数据 string grade = ds.Tables[0].Rows[0][15].ToString(); year = Convert.ToInt32(grade) + 4; } catch { year = DateTime.Now.Year; } finally { ds.Clear(); } return year; }
protected void confirm_Click(object sender, EventArgs e)///首先判断该人员是否已经安排过值班 { DB db = new DB(); string str = "SELECT jobskyerID FROM dutyTimeTable"; string jobskyerID = chooseName.SelectedValue; SqlConnection con = new SqlConnection(); con = db.GetCon(); SqlCommand com = new SqlCommand(str, con); SqlDataAdapter da = new SqlDataAdapter(com); DataSet ds = new DataSet(); da.Fill(ds); ///SqlDataReader dr = com.ExecuteReader(); int k = ds.Tables[0].Rows.Count; for (int i = 0; i < k; ++i) { if (jobskyerID == ds.Tables[0].Rows[i]["jobskyerID"].ToString()) { Update_DutyTime(); } if (i == k) { Insert_DutyTime(); } } }
public bool Insert_DutyTime()///如果选择了没有安排过值班的人,就插入值班安排数据 { string dutyInTime = chooseWeekday.SelectedValue + chooseSignInTime.SelectedValue; string dutyOutTime = chooseWeekday.SelectedValue + chooseSignOutTime.SelectedValue; string InsertStr = "INSERT INTO dutyTimeTable(dutyInTime,dutyOutTime,jobskyerID)VALUES(@dutyInTime,@dutyOutTime,@jobskyerID)"; DB db = new DB(); SqlConnection con = new SqlConnection(); con = db.GetCon(); con.Open(); SqlCommand com = new SqlCommand(InsertStr, con); com.Parameters.Add("@dutyInTime", SqlDbType.DateTime, 0).Value = Convert.ToDateTime(dutyInTime); com.Parameters.Add("@dutyOutTime", SqlDbType.DateTime, 0).Value = Convert.ToDateTime(dutyOutTime); com.Parameters.Add("@jobskyerID", SqlDbType.NChar, 0).Value = chooseName.SelectedValue; try { com.ExecuteNonQuery(); Sign_Result.Text = "安排值班成功!"; } catch (Exception ex) { Sign_Result.Text = "安排值班失败!"; return false; } finally { com.Dispose(); con.Close(); } return true; }
public bool ScoreRankList_Bind()///下拉列表绑定数据 { DB db = new DB(); string sql_game = "SELECT * FROM GAME "; SqlConnection con = new SqlConnection(); con = db.GetCon(); con.Open(); SqlCommand cmd = new SqlCommand(sql_game, con); SqlDataReader sqlRead_Game = cmd.ExecuteReader(); try { ScoreRankList.DataSource = sqlRead_Game; ScoreRankList.DataTextField = "gamName"; ScoreRankList.DataValueField = "gameID"; ScoreRankList.DataBind(); ScoreRankList.Items.Add(new ListItem("请选择","-1")); ScoreRankList.SelectedValue = "-1"; } catch (Exception ex) { return false; } finally { cmd.Dispose(); con.Close(); } return true; }
public bool ScoreRank_Bind()///分数排行绑定数据 { DB db = new DB(); string scoreRankstr = "SELECT GAME_RECORD.jobskyerID,gamScore,jobName FROM GAME_RECORD,JOBSKYER WHERE GAME_RECORD.jobskyerID=JOBSKYER.jobskyerID ORDER BY gamScore desc"; SqlConnection con = new SqlConnection(); con = db.GetCon(); con.Open(); SqlCommand com = new SqlCommand(scoreRankstr, con); SqlDataReader dr = com.ExecuteReader(); try { ScoreRank.DataSource = dr; ScoreRank.DataBind(); } catch(Exception ex) { return false; } finally { com.Dispose(); con.Close(); } return true; }
public int SelectMyScore(string username, string gameID) { int myscore = 0; SqlConnection conn = new SqlConnection(); string sqlstr = "select gamScore from GAME_RECORD where jobskyerID ='" + username + "' and gameID='" + gameID + "' "; DB db = new DB(); conn = db.GetCon(); conn.Open(); SqlCommand cmd = new SqlCommand(sqlstr, conn); try { myscore=Int32.Parse(cmd.ExecuteScalar().ToString()); return myscore;//获取个人纪录并返回 } catch (Exception ex) { return 0; } finally { cmd.Dispose(); conn.Close(); } //return myscore; }
public static string GetConfig(string param_name) { DB db = new DB(); db.Connect (); string sqlQuery = "SELECT valor FROM configuraciones WHERE evento_id = "+Evento.GetActivoID()+" AND denominacion = '"+param_name+"'"; db.dbcmd.CommandText = sqlQuery; db.reader = db.dbcmd.ExecuteReader(); string value = ""; while (db.reader.Read()) { if(!db.reader.IsDBNull(0)){ value = db.reader.GetString(0); } } db.reader.Close(); if (value == "") { sqlQuery = "SELECT valor FROM configuraciones WHERE evento_id = 0 AND denominacion = '"+param_name+"'"; db.dbcmd.CommandText = sqlQuery; db.reader = db.dbcmd.ExecuteReader(); while (db.reader.Read()) { value = db.reader.GetString(0); } db.reader.Close(); } db.reader = null; db.Disconnect (); return value; }
public Menu(int UserID) { Size MinButtonSize = new System.Drawing.Size(290, 30); InitializeComponent(); if (UserID <= 0) { Login l = new Login(); l.Show(); this.Hide(); } else { _userID = UserID; DB db = new DB(); db.AddParam("@UserID", UserID); DataTable dtMenu = db.SQLResults("usp_MenuGet"); foreach (DataRow dr in dtMenu.Rows) { Button btn = new Button(); btn.AutoSize = true; btn.BackColor = Color.Azure; btn.MinimumSize = MinButtonSize; btn.Text = dr["DisplayName"].ToString(); btn.Name = dr["MenuID"].ToString(); btn.Margin = new Padding(3,0,0,0); btn.Click += new EventHandler(btnMenu_Click); flpMenu.Controls.Add(btn); } } }
protected void Page_Load(object sender, EventArgs e) { Hashtable State = (Hashtable)HttpRuntime.Cache[Session.SessionID]; if (State == null || State.Count <= 2) { Page.ClientScript.RegisterStartupScript(this.GetType(), Guid.NewGuid().ToString(), "timeOut('../Default.aspx');", true); return; } DB db = new DB(); string sql = "SELECT * FROM stock_images WHERE "; if (State["SelectedAppType"].ToString() == Constants.WEB_APP_TYPE || State["SelectedAppType"].ToString() == Constants.HYBRID_APP_TYPE) sql += "type='jquery_buttons' or type='blank_buttons'"; else sql += "type='blank_buttons'"; DataRow[] rows = db.ViziAppsExecuteSql(State, sql); DataSet paramsDS = new DataSet("ParameterDataSet"); DataTable paramTable = paramsDS.Tables.Add("ParamTable"); DataColumn paramCol = paramTable.Columns.Add("image_url", typeof(String)); foreach (DataRow row in rows) { string type = row["type"].ToString(); string url = row["image_url"].ToString(); DataRow paramRow = paramTable.NewRow(); string[] row_array = new string[1]; row_array[0] = url; paramRow.ItemArray = row_array; paramTable.Rows.Add(paramRow); } ParamRepeater.DataSource = paramsDS; ParamRepeater.DataBind(); db.CloseViziAppsDatabase((Hashtable)HttpRuntime.Cache[Session.SessionID]); }
void ProcessResponse(string response) { if (response != "[]") { response = response.Trim (new Char[] { '{', '}' }); string[] response_exploded = response.Split (','); DB db = new DB (); db.Connect (); foreach (string pair in response_exploded) { string[] key_value = pair.Split (':'); string ext_id = key_value [1].Trim (new Char[]{'"'}); string id = key_value [0].Trim (new Char[]{'"'}); string query = "UPDATE participantes SET external_id = " + ext_id + " WHERE id = " + id; db.dbcmd.CommandText = query; if (db.dbcmd.ExecuteNonQuery () == 1) { Debug.Log ("Exportado participante id local " + id + " a la id externa " + ext_id); } } db.Disconnect (); } else { Debug.Log ("No se exportó ningun participante nuevo"); } GameObject.Find ("Button Export").GetComponent<Button> ().interactable = true; }
public void SetData( DB.Stru.优抚科.优抚对象.伤残人员.基本信息 stru ) { txt行政区划.Text = stru.行政区划; txt身份证号码.Text = stru.身份证号码 ; dat出生日期.strDate = stru.出生日期 ; cmb伤残等级.Text = stru.伤残等级 ; cmb伤残属别.Text = stru.伤残属别 ; dat参加工作时间.Text = stru.入伍时间 ; cmb劳动能力.Text = stru.劳动能力 ; cmb就业情况.Text = stru.就业情况 ; cmb户口簿住址类别.Text = stru.户口簿住址类别 ; txt姓名.Text = stru.姓名; cmb民族.Text = stru.民族; cmb性别.Text = stru.性别 ; cmb伤残性质.Text = stru.伤残性质; cmb婚姻状况.Text = stru.婚姻状况; dat退伍时间.strDate = stru.退伍时间 ; cmb生活能力.Text = stru.生活能力 ; cmb户口类别.Text = stru.户口类别 ; txt联系电话.Text = stru.联系电话 ; txt工作单位.Text = stru.工作单位 ; txt户口簿地址.Text = stru.户口簿住址 ; txt实际居住地地址.Text = stru.实际居住地址 ; txt备注.Text = stru.备注 ; }
public bool GetData( ref DB.Stru.优抚科.优抚对象.伤残人员.基本信息 stru ) { if ( !CheckBeforeSave() ) return false; stru.行政区划 = txt行政区划.Text.Trim(); stru.身份证号码 = txt身份证号码.Text.Trim(); stru.出生日期 = dat出生日期.strDate; stru.伤残等级 = cmb伤残等级.Text.Trim(); stru.伤残属别 = cmb伤残属别.Text.Trim(); stru.入伍时间 = dat参加工作时间.Text.Trim(); stru.劳动能力 = cmb劳动能力.Text.Trim(); stru.就业情况 = cmb就业情况.Text.Trim(); stru.户口簿住址类别 = cmb户口簿住址类别.Text.Trim(); stru.姓名 = txt姓名.Text.Trim(); stru.民族 = cmb民族.Text.Trim(); stru.性别 = cmb性别.Text.Trim(); stru.伤残性质 = cmb伤残性质.Text.Trim(); stru.婚姻状况 = cmb婚姻状况.Text.Trim(); stru.退伍时间 = dat退伍时间.strDate; stru.生活能力 = cmb生活能力.Text.Trim(); stru.户口类别 = cmb户口类别.Text.Trim(); stru.联系电话 = txt联系电话.Text.Trim(); stru.工作单位 = txt工作单位.Text.Trim(); stru.户口簿住址 = txt户口簿地址.Text.Trim(); stru.实际居住地址 = txt实际居住地地址.Text.Trim(); stru.备注 = txt备注.Text.Trim(); return true; }
private bool Add_Update() { try { DB DataBase = new DB("Categories"); DataBase.AddColumn("cat_name", Category_TB.Text.Trim()); if(Category_Id == null) { if(DataBase.IsNotExist("cat_id", "cat_name")) { return Confirm.Check(DataBase.Insert()); } else { Message.Show("لقد تم تسجيل هذه الفئة من قبل", MessageBoxButton.OK, 5); return false; } } else { DataBase.AddCondition("cat_id", this.Category_Id); return Confirm.Check(DataBase.Update()); } } catch { //MessageBox.Show("kiki_method"); return false; } }
public bool SelectScore(string username,string gameID){ SqlConnection conn = new SqlConnection(); string sqlstr = "select count(*) from GAME_RECORD where jobskyerID ='" + username + "' and gameID='" + gameID + "' "; DB db = new DB(); conn = db.GetCon(); conn.Open(); SqlCommand cmd = new SqlCommand(sqlstr, conn); try { if (Int32.Parse( cmd.ExecuteScalar().ToString()) == 0) { return false; } } catch (Exception ex) { return false; } finally { cmd.Dispose(); conn.Close(); } return true;//本来就有记录,就返回true }
public static int SInsert(string sql, params object[] parameter) { using (DB db = new DB()) { return db.Insert(sql, parameter); } }
public bool Save(DB.Stru.事务科.专项救助_低保边缘户 stru) { string strID = Orm.Save(stru); stru.ID = strID; return ! String.IsNullOrEmpty(strID); }
public static object SExecuteScalar(string sql, params object[] parameter) { using (DB db = new DB()) { return db.ExecuteScalar(sql, parameter); } }
public static List<object[]> SExecuteReader(string sql, params object[] parameter) { using (DB db = new DB()) { return db.ExecuteReader(sql, parameter); } }
/// <exception cref="System.IO.IOException"/> protected internal override void StartStorage() { Path storeRoot = CreateStorageDir(GetConfig()); Options options = new Options(); options.CreateIfMissing(false); options.Logger(new HistoryServerLeveldbStateStoreService.LeveldbLogger()); Log.Info("Using state database at " + storeRoot + " for recovery"); FilePath dbfile = new FilePath(storeRoot.ToString()); try { db = JniDBFactory.factory.Open(dbfile, options); } catch (NativeDB.DBException e) { if (e.IsNotFound() || e.Message.Contains(" does not exist ")) { Log.Info("Creating state database at " + dbfile); options.CreateIfMissing(true); try { db = JniDBFactory.factory.Open(dbfile, options); // store version StoreVersion(); } catch (DBException dbErr) { throw new IOException(dbErr.Message, dbErr); } } else { throw; } } CheckVersion(); }
public static bool ModulYetkileri(int fkKullanicilar, string Kod) { string sql = @"select m.ModulAdi,my.Yetki from Moduller m with(nolock) left join ModullerYetki my with(nolock) on my.Kod=m.Kod where fkKullanicilar=" + fkKullanicilar + " and m.Kod='" + Kod + "'"; DataTable dt = DB.GetData(sql); if (dt.Rows.Count == 0) { return(false); } else { if (dt.Rows[0]["Yetki"].ToString() == "0") { return(false); } else { return(true); } } }
// Reduce hp of the deck card in database, maybe also update the object public void TakeDamage(int damageAmount) { this.HP -= damageAmount; if (this.HP < 0) { this.HP = 0; } SqlConnection conn = DB.Connection(); conn.Open(); SqlCommand cmd = new SqlCommand("UPDATE decks SET HP = @DeckHP WHERE id = @DeckId;", conn); cmd.Parameters.AddWithValue("@DeckHP", this.HP); cmd.Parameters.AddWithValue("@DeckId", this.Id); cmd.ExecuteNonQuery(); if (conn != null) { conn.Close(); } }
public List <Flight> GetFlights() { SqlConnection conn = DB.Connection(); conn.Open(); SqlCommand cmd = new SqlCommand("SELECT flight_id FROM flights_cities WHERE city_id = @CityId;", conn); SqlParameter cityIdParam = new SqlParameter("@CityId", this.GetId()); cmd.Parameters.Add(cityIdParam); SqlDataReader rdr = cmd.ExecuteReader(); List <int> flightIds = new List <int> { }; while (rdr.Read()) { int flightId = rdr.GetInt32(0) flightIds.Add(flightId); } if (rdr != null) { rdr.Close(); } List <Flight> FlightList = new List <Flight> { }; foreach (int flightId in flightIds) { SqlCommand flightQuery = new SqlCommand("SELECT * FROM flights WHERE id = @FlightId;", conn); SqlParameter flightIdParam = SqlParameter } }
/** * Get Material Allocations from shipment which is not returned * @param ctx context * @param M_InOutLine_ID line * @param trxName trx * @return allocations */ public static MInOutLineMA[] getNonReturned(Ctx ctx, int M_InOutLine_ID, Trx trxName) { List <MInOutLineMA> list = new List <MInOutLineMA>(); String sql = "SELECT * FROM M_InOutLineMA WHERE M_InOutLine_ID=" + M_InOutLine_ID + " ORDER BY MMPolicyDate ASC"; DataSet ds = null; try { ds = DB.ExecuteDataset(sql, null, trxName); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow dr = ds.Tables[0].Rows[i]; list.Add(new MInOutLineMA(ctx, dr, trxName)); } ds = null; } catch (Exception e) { _log.Log(Level.SEVERE, sql, e); } MInOutLineMA[] retValue = new MInOutLineMA[list.Count]; retValue = list.ToArray(); return(retValue); }
public static List <Deck> GetAll() { SqlConnection conn = DB.Connection(); conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM decks;", conn); SqlDataReader rdr = cmd.ExecuteReader(); List <Deck> wholeDecks = new List <Deck> { }; while (rdr.Read()) { int deckId = rdr.GetInt32(0); int deckCardId = rdr.GetInt32(1); int deckPlayerId = rdr.GetInt32(2); bool deckInHand = rdr.GetBoolean(3); bool deckInPlay = rdr.GetBoolean(4); bool deckDiscard = rdr.GetBoolean(5); int deckHP = rdr.GetInt32(6); Deck newDeck = new Deck(deckCardId, deckPlayerId, deckHP, deckInHand, deckInPlay, deckDiscard, deckId); wholeDecks.Add(newDeck); } if (rdr != null) { rdr.Close(); } if (conn != null) { conn.Close(); } return(wholeDecks); }
/// <summary> /// Protected method to nullify a foreign key /// </summary> /// <param name="dbp">Secondary DB Handle</param> /// <param name="keyp">Primary Key</param> /// <param name="datap">Primary Data</param> /// <param name="fkeyp">Foreign Key</param> /// <param name="changed">Whether the foreign key has changed</param> /// <returns>0 on success, !0 on failure</returns> protected static int doNullify(IntPtr dbp, IntPtr keyp, IntPtr datap, IntPtr fkeyp, ref int changed) { DB db = new DB(dbp, false); DBT key = new DBT(keyp, false); DBT data = new DBT(datap, false); DBT fkey = new DBT(fkeyp, false); DatabaseEntry d = ((SecondaryDatabase)db.api_internal).Nullifier( DatabaseEntry.fromDBT(key), DatabaseEntry.fromDBT(data), DatabaseEntry.fromDBT(fkey)); if (d == null) { changed = 0; } else { changed = 1; data.data = d.Data; } return(0); }
protected void _Save(object sender, EventArgs e) { this.xQueryParameters.Clear(); this.xQueryValues.Clear(); this.xQueryParameters.Add((object)"@RECORDID"); this.xQueryValues.Add((object)this.RECORDID); this.xQueryParameters.Add((object)"@ESTATUS"); this.xQueryValues.Add((object)this.ESTATUS); this.xQueryParameters.Add((object)"@MOTIVOESTATUS"); this.xQueryValues.Add((object)this.MOTIVOESTATUS); this.xQueryParameters.Add((object)"@ROWGUID"); this.xQueryValues.Add((object)this.ROWGUID); this.xQueryParameters.Add((object)"@ROWUSERID"); this.xQueryValues.Add((object)this.ROWUSERID); this.xQueryParameters.Add((object)"@ROWSGXID"); this.xQueryValues.Add((object)this.ROWSGXID); this.xQuery = this.xBase + "SI"; if (!DB.ExecuteNonQuery(this.xQuery, this.xQueryParameters, this.xQueryValues, CommandType.StoredProcedure)) { return; } ((Site_Master)this.Master)._Notify("Estatus actualizado!"); this._Show((object)null, (EventArgs)null); }
//============================================ public void Save() { SqlConnection conn = DB.Connection(); conn.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO clients (name, stylist_id) OUTPUT INSERTED.id VALUES (@ClientName, @ClientStylistId);", conn); SqlParameter nameParameter = new SqlParameter(); nameParameter.ParameterName = "@ClientName"; nameParameter.Value = this.GetName(); SqlParameter stylistIdParameter = new SqlParameter(); stylistIdParameter.ParameterName = "@ClientStylistId"; stylistIdParameter.Value = this.GetStylistId(); cmd.Parameters.Add(nameParameter); cmd.Parameters.Add(stylistIdParameter); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { this._id = rdr.GetInt32(0); } if (rdr != null) { rdr.Close(); } if (conn != null) { conn.Close(); } }
public void pagebind() { string ContId = Request["ContId"]; int curpage = Convert.ToInt32(this.lblPage.Text); PagedDataSource ps = new PagedDataSource(); SqlConnection con = DB.createDB(); con.Open(); SqlDataAdapter sda = new SqlDataAdapter("select a.*,b.* from tb_Users as a join tb_hf as b on a.UserName=b.hfname where b.ContId='" + ContId + "'", con); DataSet ds = new DataSet(); sda.Fill(ds, "tb_hf"); ps.DataSource = ds.Tables["tb_hf"].DefaultView; ps.AllowPaging = true; ps.PageSize = 2; ps.CurrentPageIndex = curpage - 1; this.lnkbtnUp.Enabled = true; this.lnkbtnNext.Enabled = true; this.lnkbtnLast.Enabled = true; this.lnkbtnOne.Enabled = true; if (curpage == 1) { this.lnkbtnOne.Enabled = false; //不显示第一页按钮 this.lnkbtnUp.Enabled = false; //不显示上一页按钮 } if (curpage == ps.PageCount) { this.lnkbtnNext.Enabled = false; //不显示下一页 this.lnkbtnLast.Enabled = false; //不显示最后一页 } this.lblBackPage.Text = Convert.ToString(ps.PageCount); this.DataList2.DataSource = ps; this.DataList2.DataKeyField = "hfId"; this.DataList2.DataBind(); con.Close(); }
public object Active(string id,string isactive) { object rtn = null; id = ComFunc.nvl(id); isactive = ComFunc.nvl(isactive); BeginTrans(); var up = DB.NewDefaultDBUnitParameter<SqliteAccess>(); UnitDataCollection re = DB.Excute(up, FrameDLRObject.CreateInstanceFromat(@"{ $acttype : 'Query', $table : 'LoginInfo', $where : { LoginID:{0} } }", id)); if (IsValidBy("账号不存在", () => re.QueryTable.RowLength > 0)) { DB.Excute(up, FrameDLRObject.CreateInstanceFromat(@"{ $acttype : 'Update', $table : 'LoginInfo', IsActive:{1}, $where:{ LoginID:{0} } }", id, isactive.ToLower()=="true"?"true":"false")); rtn = new { id = id }; } CommitTrans(); SetRefreshCacheRoute($"/user/{id}"); return rtn; }
//============================================ public static Client Find(int id) { SqlConnection conn = DB.Connection(); conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM clients WHERE id = @clientId;", conn); SqlParameter clientIdParameter = new SqlParameter(); clientIdParameter.ParameterName = "@clientId"; clientIdParameter.Value = id.ToString(); cmd.Parameters.Add(clientIdParameter); SqlDataReader rdr = cmd.ExecuteReader(); int foundClientId = 0; string foundClientName = null; int foundClientStylistId = 0; while (rdr.Read()) { foundClientId = rdr.GetInt32(0); foundClientName = rdr.GetString(1); foundClientStylistId = rdr.GetInt32(2); } Client foundClient = new Client(foundClientName, foundClientStylistId, foundClientId); if (rdr != null) { rdr.Close(); } if (conn != null) { conn.Close(); } return(foundClient); }
public ActionResult Edit(int id, FormCollection collection) { try { string Images = string.Empty; Images = ToBase64(Request.Files["images"]); var db = new DB(); var Sql = db.Category.SingleOrDefault(x => x.Id == id); if (Images != string.Empty) { Sql.image = Sql.category_num + ".png"; Sql.images = Images; } UpdateModel(Sql, collection.ToValueProvider()); db.SubmitChanges(); return(RedirectToAction("Index")); } catch { return(View()); } }
public bool Login(LoginInfo LoginInfo) { bool result = false; if (SYS_MODEL == SysModel.T8) { string f1 = @"SELECT TOP 1 compno, usr, name FROM TbrSystem.dbo.PSWD Where compno='{0}' and UPPER(usr)=UPPER('{1}') and PWD_GAO='{2}' "; var list = DB.SqlQueryable <EmployeeModel>(f1.FormatOrg(LoginInfo.db_no, LoginInfo.username, ToPassWordMD5(LoginInfo.password))).ToList(); result = list.Count > 0; } else { result = false; } return(result); }
protected void Button1_Click(object sender, EventArgs e) { int i = 0; using (SqlConnection conn = new DB().GetConnection()) { SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "Delete from ArticleTags where ID in (" + IDSLabel.Text + ") "; SqlCommand cmd1 = conn.CreateCommand(); cmd1.CommandText = "Delete from Articles_ArticleTags where ArticleTagID in (" + IDSLabel.Text + ") "; conn.Open(); cmd1.ExecuteNonQuery(); i = cmd.ExecuteNonQuery(); cmd.Dispose(); cmd1.Dispose(); cmd.CommandText = "select * from ArticleTags where ID in (" + IDSLabel.Text + ") order by ID desc"; SqlDataReader rd = cmd.ExecuteReader(); GridView1.DataSource = rd; GridView1.DataBind(); rd.Close(); conn.Close(); } if (i > 0) { ResultLabel.Text = "成功删除" + i + "个标签!"; ResultLabel.ForeColor = System.Drawing.Color.Green; } else { ResultLabel.Text = "操作失败,请重试!"; ResultLabel.ForeColor = System.Drawing.Color.Red; } }
public async Task <int> SaveSubsAsync(ForceSubscription forceSubscription) { int affectedRows = 0; var chatId = forceSubscription.ChatId; var channelId = forceSubscription.ChannelId; await DB.Find <ForceSubscription>() .ManyAsync( subscription => subscription.ChatId == chatId && subscription.ChannelId == channelId ) .ContinueWith( async task => { affectedRows = task.Result.Count; if (task.Result.Count == 0) { await DB.InsertAsync <ForceSubscription>(forceSubscription); } } ); return(affectedRows); }
public ActionResult Business(AssessmentViewModel model) { DB db = new DB(); BusinessRecord record = db.BusinessRecords.Find(model.Id); if (model.quarter == "first") { record.isAssessed = 1; } else if (model.quarter == "second") { record.isAssessed = 2; } else if (model.quarter == "third") { record.isAssessed = 3; } else if (model.quarter == "fourth") { record.isAssessed = 4; } db.SaveChanges(); return(Redirect("/Collection/Business/" + record.UniqueId)); }
public IActionResult EditAnnouncementIllegal(Announcement AIllegal, int id) { var Illegal = DB.Announcement .Where(x => x.Id == id && x.TypeCS.NameType == "I") .SingleOrDefault(); if (Illegal == null) { return(Content("不存在该记录")); } else { var UserCurrent = DB.Users .Where(x => x.UserName == HttpContext.User.Identity.Name) .SingleOrDefault(); var b = DB.BaseInfo .Where(x => x.RegisteNumber == AIllegal.RegisteNumber) .SingleOrDefault(); if (b != null) { Illegal.WriteTime = DateTime.Now; Illegal.Writer = UserCurrent.UserName; Illegal.Title = AIllegal.Title; Illegal.Content = AIllegal.Content; Illegal.PublicTime = AIllegal.PublicTime; Illegal.PublicUnit = AIllegal.PublicUnit; Illegal.RegisteNumber = AIllegal.RegisteNumber; DB.SaveChanges(); return(Content("success")); } else { return(Content("nobase")); } } }
public IActionResult Upload(IFormFile file) { if (HttpContext.Session.GetString("Admin") != "true") { return(Json(new { code = 403, msg = "Forbidden" })); } if (file == null) { return(Json(new { code = 400, msg = "File not found" })); } var _file = new Blob(); _file.FileName = file.GetFileName(); _file.Time = DateTime.Now; _file.Id = Guid.NewGuid(); _file.ContentLength = file.Length; _file.ContentType = file.ContentType; _file.File = file.ReadAllBytes(); DB.Blobs.Add(_file); DB.SaveChanges(); return(Json(new { code = 200, fileId = _file.Id.ToString() })); }
private void MainPageInit(DialogPage page) { var model = GetDataModel <Model>(); var dbHouse = DB.Get <PlayerHouse>(model.OwnerUUID); var houseDetail = Housing.GetHouseTypeDetail(dbHouse.HouseType); var furnitureDetail = Housing.GetFurnitureDetail(model.FurnitureType); page.Header = ColorToken.Green("Furniture: ") + furnitureDetail.Name + "\n" + ColorToken.Green("Furniture Limit: ") + dbHouse.Furnitures.Count + " / " + houseDetail.FurnitureLimit + "\n\n" + "Please select an action to take."; // Furniture has been placed. Only give options to adjust positioning/rotation if (model.HasBeenPlaced) { page.AddResponse("Pick Up", PickUpFurniture); page.AddResponse("Move", () => ChangePage(MovePageId)); page.AddResponse("Rotate", () => ChangePage(RotatePageId)); } // Furniture hasn't been placed yet. else { page.AddResponse("Place", PlaceFurniture); } }
public void CallNutritionApi(string NDBNo, int ProductID) { try { HttpClient client = new HttpClient(); client.BaseAddress = new Uri("http://api.nal.usda.gov/ndb/reports/?format=json&type=b&api_key=HBS3lRZUgBIxXOSF1DQBKW7GJw6M6e2J4cFMzSSP&ndbno=" + NDBNo + ""); client.DefaultRequestHeaders.Accept.Add( new MediaTypeWithQualityHeaderValue("application/json")); HttpResponseMessage response = client.GetAsync(client.BaseAddress).Result; if (response.IsSuccessStatusCode) { var dataObject = response.Content.ReadAsAsync <rootObject>().Result; foreach (nutrients nutrient in dataObject.report.food.nutrients) { int TblPrimaryKey = 0; object objNT = DB.ExecuteScalar("select va019_nutrition_id from va019_nutrition where m_product_id=" + ProductID + " and va019_nutrition_key=" + nutrient.nutrient_id + ""); if (objNT != null && objNT != DBNull.Value) { TblPrimaryKey = Convert.ToInt32(objNT); } var Dll = Assembly.Load("VA019Svc"); var X_VA019_Nutrition = Dll.GetType("ViennaAdvantage.Model.MVA019Nutrition"); ConstructorInfo conInfo = X_VA019_Nutrition.GetConstructor(new[] { typeof(Ctx), typeof(int), typeof(Trx), typeof(int), typeof(string), typeof(int), typeof(string), typeof(decimal) }); conInfo.Invoke(new object[] { p_ctx, TblPrimaryKey, null, ProductID, nutrient.name, nutrient.nutrient_id, nutrient.unit, nutrient.value }); } } else { log.SaveError("Nutretion API Response Falier", ""); } } catch (Exception e) { log.SaveError("Nutretion API Error", e); } }
public IActionResult Base64String(string file) { if (HttpContext.Session.GetString("Admin") != "true") { return(Json(new { code = 403, msg = "Forbidden" })); } if (file == null) { return(Json(new { code = 400, msg = "File not found" })); } var img = new Base64StringImage(file); var _file = new Blob(); _file.FileName = "file"; _file.Time = DateTime.Now; _file.Id = Guid.NewGuid(); _file.ContentType = img.ContentType; _file.File = img.AllBytes; _file.ContentLength = _file.File.Length; DB.Blobs.Add(_file); DB.SaveChanges(); return(Json(new { code = 200, fileId = _file.Id.ToString() })); }
protected void _SaveNotasPX(object sender, EventArgs e) { if (txtnotaspx.Value.Trim() == "") { txtnotaspx.Focus(); Notify("Debe especificar un comentario", "error"); return; } if (Request.QueryString["PROCESO"].ToString() == "NotasPX") { xsucursal = Request.QueryString["SUCURSAL"].ToString(); xpaciente = Request.QueryString["PACIENTE"].ToString(); if (DB.ExecuteNonQuery(string.Format("[PR_PAX00000_NotasGuardar] '{0}','{1}','{2}'", (object)xpaciente.ToString().Trim(), (object)xsucursal.ToString().Trim(), txtnotaspx.Value.Trim()))) { lblnotaspx.Text = "Cambio realizado con exito"; lblnotaspx.ForeColor = System.Drawing.Color.Blue; } else { lblnotaspx.ForeColor = System.Drawing.Color.Blue; } } }
/// <summary> /// Summary for calculation ShippingByTotalByPercent /// </summary> /// <returns>Return a collection of ShippingMethod based on the computation of ShippingByTotalByPercent</returns> public override ShippingMethodCollection GetShippingMethods(int storeId) { ShippingMethodCollection availableShippingMethods = new ShippingMethodCollection(); bool shippingMethodToStateMapIsEmpty = Shipping.ShippingMethodToStateMapIsEmpty(); bool shippingMethodToCountryMapIsEmpty = Shipping.ShippingMethodToCountryMapIsEmpty(); decimal extraFee = AppLogic.AppConfigUSDecimal("ShippingHandlingExtraFee"); string shipsql = GenerateShippingMethodsQuery(storeId, false); //shipsql.Append("select * from ShippingMethod with (NOLOCK) where IsRTShipping=0 "); //if (!shippingMethodToStateMapIsEmpty && !ThisCustomer.IsRegistered) //{ // shipsql.Append(" and ShippingMethodID in (select ShippingMethodID from ShippingMethodToStateMap with (NOLOCK))"); //} //if (!shippingMethodToStateMapIsEmpty && ThisCustomer.IsRegistered) //{ // shipsql.Append(" and ShippingMethodID in (select ShippingMethodID from ShippingMethodToStateMap with (NOLOCK) where StateID=" + AppLogic.GetStateID(this.ShippingAddress.State).ToString() + ")"); //} //if (!shippingMethodToCountryMapIsEmpty) //{ // shipsql.Append(" and ShippingMethodID in (select ShippingMethodID from ShippingMethodToCountryMap with (NOLOCK) where CountryID=" + AppLogic.GetCountryID(this.ShippingAddress.Country).ToString() + ")"); //} //shipsql.Append(" order by Displayorder"); decimal SubTotalWithoutDownload = this.Cart.SubTotal(true, false, false, true, true, false, 0, true); using (SqlConnection dbconn = new SqlConnection(DB.GetDBConn())) { dbconn.Open(); using (IDataReader reader = DB.GetRS(shipsql.ToString(), dbconn)) { while (reader.Read()) { ShippingMethod thisMethod = new ShippingMethod(); thisMethod.Id = DB.RSFieldInt(reader, "ShippingMethodID"); thisMethod.Name = DB.RSFieldByLocale(reader, "Name", ThisCustomer.LocaleSetting); thisMethod.IsFree = this.ShippingIsFreeIfIncludedInFreeList && Shipping.ShippingMethodIsInFreeList(thisMethod.Id); if (thisMethod.IsFree) { thisMethod.Freight = decimal.Zero; thisMethod.ShippingIsFree = true; } else { decimal freight = Shipping.GetShipByTotalByPercentCharge(thisMethod.Id, SubTotalWithoutDownload); // exclude download items! if (extraFee > System.Decimal.Zero) { freight += extraFee; } else if (freight > System.Decimal.Zero && extraFee > System.Decimal.Zero) { freight += extraFee; } if (freight < 0) { freight = 0; } thisMethod.Freight = freight; } bool include = !(this.ExcludeZeroFreightCosts == true && (thisMethod.Freight == decimal.Zero && !thisMethod.IsFree)); if (include) { availableShippingMethods.Add(thisMethod); } } } } return(availableShippingMethods); }
private void frmDetailOrder_Load(object sender, EventArgs e) { OrderPath1 = DB.GetSettingS("OrderPath1"); OrderPath2 = DB.GetSettingS("OrderPath2"); }
void BindShippingCalculationTable(bool addInsertRow) { //clear the columns to prevent duplicates ShippingGrid.Columns.Clear(); //We're going to assemble the datasource that we need by putting it together manually here. using (DataTable gridData = new DataTable()) { //We'll need shipping method shipping charge amounts to work with in building the data source using (DataTable methodAmountsData = new DataTable()) { //Populate shipping methods data using (SqlConnection sqlConnection = new SqlConnection(DB.GetDBConn())) { sqlConnection.Open(); string getShippingMethodMapping = "exec aspdnsf_GetStoreShippingMethodMapping @StoreID = @StoreId, @IsRTShipping = 0, @OnlyMapped = @FilterByStore"; var getShippingMethodMappingParams = new[] { new SqlParameter("@StoreId", SelectedStoreId), new SqlParameter("@FilterByStore", FilterShipping), }; using (IDataReader rs = DB.GetRS(getShippingMethodMapping, getShippingMethodMappingParams, sqlConnection)) methodAmountsData.Load(rs); } if (methodAmountsData.Rows.Count == 0) { AlertMessage.PushAlertMessage(String.Format("You do not have any shipping methods setup for the selected store. Please <a href=\"{0}\">click here</a> to set them up.", AppLogic.AdminLinkUrl("shippingmethods.aspx")), AspDotNetStorefrontControls.AlertMessage.AlertType.Error); ShippingRatePanel.Visible = false; return; } using (DataTable shippingRangeData = new DataTable()) { using (SqlConnection sqlConnection = new SqlConnection(DB.GetDBConn())) { //populate the shipping range data var sqlShipping = @"SELECT DISTINCT stp.RowGuid,stp.LowValue,stp.HighValue,stp.MinimumCharge,stp.SurCharge FROM ShippingByTotalByPercent stp with (NOLOCK) INNER JOIN ShippingMethod sm WITH (NOLOCK) ON sm.ShippingMethodid = stp.ShippingMethodId AND (@FilterByStore = 0 or @StoreId = stp.StoreID) order by LowValue" ; var shippingRangeParams = new[] { new SqlParameter("@StoreId", SelectedStoreId), new SqlParameter("@FilterByStore", FilterShipping), }; sqlConnection.Open(); using (IDataReader rs = DB.GetRS(sqlShipping, shippingRangeParams, sqlConnection)) shippingRangeData.Load(rs); } //Add the data columns we'll need on our table and add grid columns to match gridData.Columns.Add(new DataColumn("RowGuid", typeof(string))); gridData.Columns.Add(new DataColumn("LowValue", typeof(string))); BoundField boundField = new BoundField(); boundField.DataField = "LowValue"; boundField.HeaderText = "Low"; boundField.ControlStyle.CssClass = "text-4"; ShippingGrid.Columns.Add(boundField); gridData.Columns.Add(new DataColumn("HighValue", typeof(string))); boundField = new BoundField(); boundField.DataField = "HighValue"; boundField.HeaderText = "High"; boundField.ControlStyle.CssClass = "text-4"; ShippingGrid.Columns.Add(boundField); gridData.Columns.Add(new DataColumn("MinimumCharge", typeof(string))); boundField = new BoundField(); boundField.DataField = "MinimumCharge"; boundField.HeaderText = "Minimum Dollar Amount"; boundField.ControlStyle.CssClass = "text-4"; ShippingGrid.Columns.Add(boundField); gridData.Columns.Add(new DataColumn("SurCharge", typeof(string))); boundField = new BoundField(); boundField.DataField = "SurCharge"; boundField.HeaderText = "Base Dollar Amount"; boundField.ControlStyle.CssClass = "text-4"; ShippingGrid.Columns.Add(boundField); //Add shipping method columns to our grid data foreach (DataRow methodAmountsRow in methodAmountsData.Rows) { var columnName = String.Format("MethodAmount_{0}", DB.RowField(methodAmountsRow, "ShippingMethodID")); gridData.Columns.Add(new DataColumn(columnName, typeof(string))); //add a column to the gridview to hold the data boundField = new BoundField(); boundField.DataField = columnName; boundField.HeaderText = DB.RowFieldByLocale(methodAmountsRow, "Name", LocaleSetting); boundField.ControlStyle.CssClass = "text-4"; ShippingGrid.Columns.Add(boundField); } //now that our columns are setup add rows to our table foreach (DataRow rangeRow in shippingRangeData.Rows) { var newRow = gridData.NewRow(); //add the range data newRow["RowGuid"] = rangeRow["RowGuid"]; newRow["LowValue"] = rangeRow["LowValue"]; newRow["HighValue"] = rangeRow["HighValue"]; newRow["MinimumCharge"] = rangeRow["MinimumCharge"]; newRow["SurCharge"] = rangeRow["SurCharge"]; //add shipping method amounts to our grid data foreach (DataRow methodAmountsRow in methodAmountsData.Rows) { var shippingMethodId = DB.RowFieldInt(methodAmountsRow, "ShippingMethodID"); var shippingRangeGuid = DB.RowFieldGUID(rangeRow, "RowGUID"); Decimal surCharge; // not used here Decimal minimumCharge; // not used here var amount = Shipping.GetShipByTotalByPercentCharge(shippingMethodId, shippingRangeGuid, out minimumCharge, out surCharge); var localizedAmount = Localization.CurrencyStringForDBWithoutExchangeRate(amount); var colName = String.Format("MethodAmount_{0}", shippingMethodId); newRow[colName] = localizedAmount; } gridData.Rows.Add(newRow); } //if we're inserting, add an empty row to the end of the table if (addInsertRow) { var newRow = gridData.NewRow(); //add the range data newRow["RowGuid"] = 0; newRow["LowValue"] = 0; newRow["HighValue"] = 0; newRow["MinimumCharge"] = 0; newRow["SurCharge"] = 0; //add shipping method columns to our insert row foreach (DataRow methodAmountsRow in methodAmountsData.Rows) { var shippingMethodId = DB.RowFieldInt(methodAmountsRow, "ShippingMethodID"); var amount = 0; var localizedAmount = Localization.CurrencyStringForDBWithoutExchangeRate(amount); var colName = String.Format("MethodAmount_{0}", shippingMethodId); newRow[colName] = localizedAmount; } gridData.Rows.Add(newRow); //if we're inserting than we'll want to make the insert row editable ShippingGrid.EditIndex = gridData.Rows.Count - 1; } //add the delete button column ButtonField deleteField = new ButtonField(); deleteField.ButtonType = ButtonType.Link; deleteField.Text = "<i class=\"fa fa-times\"></i> Delete"; deleteField.CommandName = "Delete"; deleteField.ControlStyle.CssClass = "delete-link"; deleteField.ItemStyle.Width = 94; ShippingGrid.Columns.Add(deleteField); //add the edit button column CommandField commandField = new CommandField(); commandField.ButtonType = ButtonType.Link; commandField.ShowEditButton = true; commandField.ShowDeleteButton = false; commandField.ShowCancelButton = true; commandField.ControlStyle.CssClass = "edit-link"; commandField.EditText = "<i class=\"fa fa-share\"></i> Edit"; commandField.CancelText = "<i class=\"fa fa-reply\"></i> Cancel"; commandField.UpdateText = "<i class=\"fa fa-floppy-o\"></i> Save"; commandField.ItemStyle.Width = 84; ShippingGrid.Columns.Add(commandField); ShippingGrid.DataSource = gridData; ShippingGrid.DataBind(); } } } btnInsert.Visible = !addInsertRow; //Hide the 'add new row' button while editing/inserting to avoid confusion and lost data }
bool TryUpdateShippingRow(GridViewRow row, string guid) { var newGuid = DB.GetNewGUID(); //loop through the colums and update each shipping method with the appropriate value var indexCounter = 0; foreach (var column in ShippingGrid.Columns) { //skip past the low and high value columns and make sure we've got a bound field if (indexCounter > 3 && column.GetType() == typeof(BoundField)) { var field = (BoundField)column; if (field.DataField.Contains("MethodAmount_")) { var methodId = field.DataField.Replace("MethodAmount_", String.Empty); decimal lowValue = 0; if (!decimal.TryParse(((TextBox)(row.Cells[0].Controls[0])).Text, out lowValue)) { AlertMessage.PushAlertMessage("Your low value is not in the correct format.", AspDotNetStorefrontControls.AlertMessage.AlertType.Error); return(false); } decimal highValue = 0; if (!decimal.TryParse(((TextBox)(row.Cells[1].Controls[0])).Text, out highValue)) { AlertMessage.PushAlertMessage("Your high value is not in the correct format.", AspDotNetStorefrontControls.AlertMessage.AlertType.Error); return(false); } decimal minimumChargeAmount = 0; if (!decimal.TryParse(((TextBox)(row.Cells[2].Controls[0])).Text, out minimumChargeAmount)) { AlertMessage.PushAlertMessage("The minimum amount you entered is not in the correct format.", AspDotNetStorefrontControls.AlertMessage.AlertType.Error); return(false); } decimal surChargeAmount = 0; if (!decimal.TryParse(((TextBox)(row.Cells[3].Controls[0])).Text, out surChargeAmount)) { AlertMessage.PushAlertMessage("The base amount you entered is not in the correct format.", AspDotNetStorefrontControls.AlertMessage.AlertType.Error); return(false); } decimal percentOfTotal = 0; if (!decimal.TryParse(((TextBox)(row.Cells[indexCounter].Controls[0])).Text, out percentOfTotal)) { AlertMessage.PushAlertMessage("The percentage you entered for one of your shipping methods is not in the correct format.", AspDotNetStorefrontControls.AlertMessage.AlertType.Error); return(false); } if (lowValue >= highValue) { AlertMessage.PushAlertMessage("Please enter a valid range for your low and high values", AspDotNetStorefrontControls.AlertMessage.AlertType.Error); return(false); } //passed validation. delete the old row and create a new one. if (guid != "0") { DB.ExecuteSQL("delete from ShippingByTotalByPercent where RowGUID = @Guid ", new[] { new SqlParameter("Guid", guid) }); } var parameters = new[] { new SqlParameter("@ShippingGuid", newGuid), new SqlParameter("@LowAmount", lowValue), new SqlParameter("@HighAmount", highValue), new SqlParameter("@ShippingMethodId", methodId), new SqlParameter("@MinimumCharge", minimumChargeAmount), new SqlParameter("@SurCharge", surChargeAmount), new SqlParameter("@PercentOfTotal", percentOfTotal), new SqlParameter("@StoreId", SelectedStoreId), }; var insertSql = @"insert into ShippingByTotalByPercent(RowGUID, LowValue, HighValue, ShippingMethodID, MinimumCharge, SurCharge, PercentOfTotal, StoreID) values(@ShippingGuid, @LowAmount, @HighAmount, @ShippingMethodId, @MinimumCharge, @SurCharge, @PercentOfTotal, @StoreId)" ; DB.ExecuteSQL(insertSql, parameters); } } indexCounter++; } return(true); }
public static bool InsertForeignCostMatchOrder(Ctx ctx, MOrderLine orderLine, decimal matchQty, int ASI, Trx trx) { int acctSchema_ID = 0; int M_CostElement_ID = 0; int AD_Org_ID = 0; int M_ASI_ID = 0; MProduct product = null; MAcctSchema acctSchema = null; MCostForeignCurrency foreignCost = null; dynamic pc = null; String cl = null; MOrder order = null; try { order = new MOrder(ctx, orderLine.GetC_Order_ID(), trx); if (!order.IsSOTrx() && !order.IsReturnTrx()) { acctSchema_ID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT asch.c_acctschema_id FROM c_acctschema asch INNER JOIN ad_clientinfo ci ON ci.c_acctschema1_id = asch.c_acctschema_id WHERE ci.ad_client_id = " + order.GetAD_Client_ID())); acctSchema = new MAcctSchema(ctx, acctSchema_ID, trx); if (acctSchema.GetC_Currency_ID() != order.GetC_Currency_ID()) { // Get Costing Element of Av. PO M_CostElement_ID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT M_CostElement_ID FROM M_CostElement WHERE AD_Client_ID = " + order.GetAD_Client_ID() + " AND IsActive = 'Y' AND CostingMethod = 'A'")); product = new MProduct(ctx, orderLine.GetM_Product_ID(), trx); if (product != null && product.GetProductType() == "I" && product.GetM_Product_ID() > 0) // for Item Type product { pc = MProductCategory.Get(product.GetCtx(), product.GetM_Product_Category_ID()); // Get Costing Level if (pc != null) { cl = pc.GetCostingLevel(); } if (cl == null) { cl = acctSchema.GetCostingLevel(); } if (cl == "C" || cl == "B") { AD_Org_ID = 0; } else { AD_Org_ID = order.GetAD_Org_ID(); } if (cl != "B") { M_ASI_ID = 0; } else { M_ASI_ID = ASI; } foreignCost = MCostForeignCurrency.Get(product, M_ASI_ID, AD_Org_ID, M_CostElement_ID, order.GetC_BPartner_ID(), order.GetC_Currency_ID()); foreignCost.SetC_Order_ID(order.GetC_Order_ID()); foreignCost.SetCumulatedQty(Decimal.Add(foreignCost.GetCumulatedQty(), matchQty)); foreignCost.SetCumulatedAmt(Decimal.Add(foreignCost.GetCumulatedAmt(), Decimal.Multiply(orderLine.GetPriceActual(), matchQty))); if (foreignCost.GetCumulatedQty() != 0) { foreignCost.SetCostPerUnit(Decimal.Round(Decimal.Divide(foreignCost.GetCumulatedAmt(), foreignCost.GetCumulatedQty()), acctSchema.GetCostingPrecision())); } else { foreignCost.SetCostPerUnit(0); } if (!foreignCost.Save(trx)) { ValueNamePair pp = VLogger.RetrieveError(); _log.Severe("Error occured during updating M_Cost_ForeignCurrency. Error name : " + pp.GetName() + " AND Error Value : " + pp.GetValue() + " , For Invoice line : " + orderLine.GetC_OrderLine_ID() + " , AND Ad_Client_ID : " + orderLine.GetAD_Client_ID()); return(false); } } } } } catch (Exception ex) { _log.Log(Level.SEVERE, "", ex); return(false); } return(true); }
public static bool InsertForeignCostAverageInvoice(Ctx ctx, MInvoice invoice, MInvoiceLine invoiceLine, Trx trx) { int acctSchema_ID = 0; int M_CostElement_ID = 0; int AD_Org_ID = 0; int M_ASI_ID = 0; MProduct product = null; MAcctSchema acctSchema = null; MCostForeignCurrency foreignCost = null; dynamic pc = null; String cl = null; try { // if cost is calculated then not to calculate again if (invoiceLine.IsFutureCostCalculated()) { return(true); } acctSchema_ID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT asch.c_acctschema_id FROM c_acctschema asch INNER JOIN ad_clientinfo ci ON ci.c_acctschema1_id = asch.c_acctschema_id WHERE ci.ad_client_id = " + invoice.GetAD_Client_ID())); acctSchema = new MAcctSchema(ctx, acctSchema_ID, trx); if (acctSchema.GetC_Currency_ID() != invoice.GetC_Currency_ID()) { // Get Costing Element of Av. Invoice M_CostElement_ID = Util.GetValueOfInt(DB.ExecuteScalar(@"SELECT M_CostElement_ID FROM M_CostElement WHERE AD_Client_ID = " + invoice.GetAD_Client_ID() + " AND IsActive = 'Y' AND CostingMethod = 'I'")); product = new MProduct(ctx, invoiceLine.GetM_Product_ID(), trx); if (product != null && product.GetProductType() == "I" && product.GetM_Product_ID() > 0) // for Item Type product { pc = MProductCategory.Get(product.GetCtx(), product.GetM_Product_Category_ID()); // Get Costing Level if (pc != null) { cl = pc.GetCostingLevel(); } if (cl == null) { cl = acctSchema.GetCostingLevel(); } if (cl == "C" || cl == "B") { AD_Org_ID = 0; } else { AD_Org_ID = invoice.GetAD_Org_ID(); } if (cl != "B") { M_ASI_ID = 0; } else { M_ASI_ID = invoiceLine.GetM_AttributeSetInstance_ID(); } foreignCost = MCostForeignCurrency.Get(product, M_ASI_ID, AD_Org_ID, M_CostElement_ID, invoice.GetC_BPartner_ID(), invoice.GetC_Currency_ID()); foreignCost.SetC_Invoice_ID(invoice.GetC_Invoice_ID()); foreignCost.SetCumulatedQty(Decimal.Add(foreignCost.GetCumulatedQty(), invoiceLine.GetQtyInvoiced())); foreignCost.SetCumulatedAmt(Decimal.Add(foreignCost.GetCumulatedAmt(), invoiceLine.GetLineNetAmt())); if (foreignCost.GetCumulatedQty() != 0) { foreignCost.SetCostPerUnit(Decimal.Round(Decimal.Divide(foreignCost.GetCumulatedAmt(), foreignCost.GetCumulatedQty()), acctSchema.GetCostingPrecision())); } else { foreignCost.SetCostPerUnit(0); } if (!foreignCost.Save(trx)) { ValueNamePair pp = VLogger.RetrieveError(); _log.Severe("Error occured during updating M_Cost_ForeignCurrency. Error name : " + pp.GetName() + " AND Error Value : " + pp.GetValue() + " , For Invoice line : " + invoiceLine.GetC_InvoiceLine_ID() + " , AND Ad_Client_ID : " + invoiceLine.GetAD_Client_ID()); return(false); } else { invoiceLine.SetIsFutureCostCalculated(true); if (!invoiceLine.Save(trx)) { ValueNamePair pp = VLogger.RetrieveError(); _log.Severe("Error occured during updating Is Foreign Cost On C_invoice. Error name : " + pp.GetName() + " AND Error Value : " + pp.GetValue() + " , For Invoice line : " + invoiceLine.GetC_InvoiceLine_ID() + " , AND Ad_Client_ID : " + invoiceLine.GetAD_Client_ID()); return(false); } } } } } catch (Exception ex) { _log.Log(Level.SEVERE, "", ex); return(false); } return(true); }
protected override String DoIt() { string sql = "Select ad_table_id from ad_table where tablename='C_Lead'"; int leadTable_ID = Util.GetValueOfInt(DB.ExecuteScalar(sql)); sql = "Select ad_table_id from ad_table where tablename='C_BPartner'"; int BPartnerTable_ID = Util.GetValueOfInt(DB.ExecuteScalar(sql)); VAdvantage.Model.X_C_TargetList TList = new VAdvantage.Model.X_C_TargetList(GetCtx(), 0, null); if (Table_id == leadTable_ID)// C_Lead { VAdvantage.Model.X_C_Lead lead = new VAdvantage.Model.X_C_Lead(GetCtx(), Record_ID, null); TList.Set_ValueNoCheck("C_MasterTargetList_ID", Campaign_id); // TList.SetC_MasterTargetList_ID(Campaign_id); TList.SetC_Lead_ID(Record_ID); TList.SetAddress1(lead.GetAddress1()); TList.SetAddress2(lead.GetAddress2()); TList.SetC_City_ID(lead.GetC_City_ID()); TList.SetCity(lead.GetCity()); TList.SetC_Region_ID(lead.GetC_Region_ID()); TList.SetRegionName(lead.GetRegionName()); TList.SetC_Country_ID(lead.GetC_Country_ID()); TList.SetPostal(lead.GetPostal()); if (TList.Save()) { return(Msg.GetMsg(GetCtx(), "TargetListCreate")); } return(Msg.GetMsg(GetCtx(), "TargetListNotCreate")); } if (Table_id == BPartnerTable_ID) // C_BPartner { string Query = "select isprospect from c_bpartner where c_bpartner_id=" + Record_ID; string P = Util.GetValueOfString(DB.ExecuteScalar(Query)); if (P == "Y") { // TList.SetC_MasterTargetList_ID(Campaign_id); TList.Set_ValueNoCheck("C_MasterTargetList_ID", Campaign_id); TList.SetRef_BPartner_ID(Record_ID); sql = "Select C_Location_id from c_bpartner_Location where c_bpartner_id=" + Record_ID; object locID = DB.ExecuteScalar(sql); TList.SetC_Location_ID(Util.GetValueOfInt(locID)); } else { Query = "select iscustomer from c_bpartner where c_bpartner_id=" + Record_ID; P = Util.GetValueOfString(DB.ExecuteScalar(Query)); if (P == "Y") { //TList.SetC_MasterTargetList_ID(Campaign_id); TList.Set_ValueNoCheck("C_MasterTargetList_ID", Campaign_id); TList.SetC_BPartner_ID(Record_ID); sql = "Select C_Location_id from c_bpartner_Location where c_bpartner_id=" + Record_ID; object locID = DB.ExecuteScalar(sql); TList.SetC_Location_ID(Util.GetValueOfInt(locID)); } else { return(Msg.GetMsg(GetCtx(), "TargetListNotCreate")); } } if (TList.Save()) { return(Msg.GetMsg(GetCtx(), "TargetListCreate")); } return(Msg.GetMsg(GetCtx(), "TargetListNotCreate")); } return(Msg.GetMsg(GetCtx(), "TargetListCreate")); }