public int Update(KISModel model) { string sql = string.Format("update KISData set AccountName='{0}',InvoiceFrom='{1}',InvoiceTo='{2}',PayableTo='{3}'," + "PayableFrom='{4}',InvoiceDate='{5}',PayableDate='{6}',IP='{7}',UserID='{8}',Pwd='{9}'", model.AccountName, model.InvoiceFrom, model.InvoiceTo, model.PayableTo, model.PayableFrom, model.InvoiceDate, model.PayableDate, model.IP, model.UserID, model.Pwd); using (SqlConnection conn = new SqlConnection(DBConn)) { conn.Open(); SqlCommand objCommand = new SqlCommand(sql, conn); objCommand.ExecuteNonQuery(); conn.Close(); } return(1); }
public KISModel ReaderBind(IDataReader dataReader) { KISModel model = new KISModel(); model.AccountName = dataReader["AccountName"].ToString(); model.InvoiceFrom = dataReader["InvoiceFrom"].ToString(); model.InvoiceTo = dataReader["InvoiceTo"].ToString(); model.PayableFrom = dataReader["PayableFrom"].ToString(); model.PayableTo = dataReader["PayableTo"].ToString(); model.InvoiceDate = dataReader["InvoiceDate"].ToString(); model.PayableDate = dataReader["PayableDate"].ToString(); model.Message = dataReader["Message"].ToString(); model.IP = dataReader["IP"].ToString(); model.UserID = dataReader["UserID"].ToString(); model.Pwd = dataReader["Pwd"].ToString(); return(model); }
public KISModel GetKIS() { var kis = new KISModel(); string sql = "select * from KISData;"; using (SqlConnection conn = new SqlConnection(DBConn)) { conn.Open(); SqlCommand objCommand = new SqlCommand(sql, conn); using (SqlDataReader objReader = objCommand.ExecuteReader()) { if (objReader.Read()) { kis = ReaderBind(objReader); } objReader.Close(); } conn.Close(); } return(kis); }