protected void btnSave_Click(object sender, EventArgs e) { try { RoomTypes room = new RoomTypes(); room.RoomType_EN = txtTypeEn.Text; room.RoomType_AR = txtTypeAr.Text; room.Description = txtDesc.Text; SqlDateTime now = SqlDateTime.Parse(DateTime.Now.ToString()); room.LastModifiedUser = 1; room.LastModifiedDate = now; if (Session["Prop_Action"] == "U") { room.RoomType_ID = int.Parse(txtTypeID.Value); bool retval = room.Update(); } else { room.CreatedUser = 1; room.CreatedDate = now; bool retval = room.Insert(); } lblMsg.Text = "Data Saved successfully."; lblMsg.ForeColor = Color.Green; Response.Redirect("RoomTypes.aspx", true); } catch (Exception ex) { lblMsg.Text = "Data not Saved ."; lblMsg.ForeColor = Color.Red; } }
protected void btnSave_Click(object sender, EventArgs e) { try { RoomTypes room = new RoomTypes(); room.RoomType_EN = txtTypeEn.Text; room.RoomType_AR = txtTypeEn.Text /*txtTypeAr.Text*/; room.Description = txtDesc.Text; SqlDateTime now = SqlDateTime.Parse(DateTime.Now.ToString()); room.LastModifiedUser = Utility.GetUserIdFromUserName(HttpContext.Current.User.Identity.Name); room.LastModifiedDate = Utility.GetSqlDateTimeFromDateTime(DateTime.Now); room.IsOnline = (SqlBoolean)chkIsOnline.Checked; if (Session["Prop_Action"] == "U") { room.RoomType_ID = int.Parse(txtTypeID.Value); bool retval = room.Update(); } else { room.CreatedUser = Utility.GetUserIdFromUserName(HttpContext.Current.User.Identity.Name); room.CreatedDate = Utility.GetSqlDateTimeFromDateTime(DateTime.Now); bool retval = room.Insert(); } lblMsg.Text = "Data Saved successfully."; lblMsg.ForeColor = Color.Green; Response.Redirect("RoomTypes.aspx", true); } catch (Exception ex) { lblMsg.Text = "Data not Saved ."; lblMsg.ForeColor = Color.Red; } }
protected void btnSave_Click(object sender, EventArgs e) { try { Properties property = new Properties(); property.PropertyName_EN = txtProNameEn.Text; property.PropertyName_AR = txtProNameAr.Text; property.Description = txtDesc.Text; property.LastModifiedUser = 1; property.LastModifiedDate = SqlDateTime.Parse(DateTime.Now.ToString()); if (Session["Prop_Action"] == "U") { property.PropertyID = int.Parse(txtPropertyID.Value); bool retval = property.Update(); } else { property.CreatedUser = 1; property.CreatedDate = property.LastModifiedDate; bool retval = property.Insert(); } lblMsg.Text = "Data Saved successfully."; lblMsg.ForeColor = Color.Green; Response.Redirect("Properties.aspx", true); } catch (Exception ex) { lblMsg.Text = "Data not Saved ."; lblMsg.ForeColor = Color.Red; } }
public void TestSamoJednoPodrucjeNullString() { List <PodaciIzBaze> list = new List <PodaciIzBaze>(); list.Add(new PodaciIzBaze(null, SqlDateTime.Parse(DateTime.Now.ToString()), 234)); new ObradaPodatakaZaDB().SamoPoJednoPodrucje(list); }
public override Expression Build() { object value = null; switch (_typeName) { case ("SqlBoolean"): value = SqlBoolean.Parse(_stringValue); break; case ("SqlInt32"): value = SqlInt32.Parse(_stringValue); break; case ("SqlString"): value = new SqlString(_stringValue); break; case ("SqlDouble"): value = SqlDouble.Parse(_stringValue); break; case ("SqlDateTime"): value = SqlDateTime.Parse(_stringValue); break; } Expression result = Expression.Constant(value, typeof(object)); return(result); }
//creates random birthday dates public static SqlDateTime GetRandomDate(DateTime from, DateTime to, Random r) { var range = to - from; var randTimeSpan = new TimeSpan((long)(r.NextDouble() * range.Ticks)); return(SqlDateTime.Parse((from + randTimeSpan).Date.ToString("yyyy-MM-dd HH:mm:ss"))); }
public async Task <ActionResult> DateAndPlaceChoice(FormCollection collection) { int parkName = Int32.Parse(collection["name"]); var date = collection["StartMonth"]; String startDate = collection["StartYear"] + "." + collection["StartMonth"] + "." + collection["StartDay"]; String endDate = collection["EndYear"] + "." + collection["EndMonth"] + "." + collection["EndDay"]; DateTime dtStart = DateTime.ParseExact(startDate, "yyyy.mm.dd", null); DateTime dtEnd = DateTime.ParseExact(endDate, "yyyy.mm.dd", null); SqlDateTime start = SqlDateTime.Parse(dtStart.ToString("yyyy/mm/dd")); SqlDateTime end = SqlDateTime.Parse(dtEnd.ToString("yyyy/mm/dd")); if (ModelState.IsValid) { string query = "SELECT vehicule.* FROM vehicule " + "LEFT JOIN reservation ON vehicule.vehiculeId = reservation.vehiculeFK " + "WHERE vehicule.parkingFK = @p0 " + "AND ( reservation.debutDate >= @p1 OR reservation.finDate <= @p2) " + "EXCEPT SELECT vehicule.* " + "FROM vehicule " + "LEFT JOIN reservation ON vehicule.vehiculeId = reservation.vehiculeFK " + "WHERE vehicule.parkingFK = @p0 " + "AND NOT(reservation.debutDate >= @p1 OR reservation.finDate <= @p2)"; IList <Vehicule> carList = await db.vehicule.SqlQuery(query, parkName, end, start).ToListAsync(); TempData["voituresRequete"] = carList; Session["startDate"] = dtStart; Session["endDate"] = dtEnd; return(RedirectToAction("BookableVehicles")); } return(View()); }
public void TestSamoJednoPodrucjeVremeInvalid() { List <PodaciIzBaze> list = new List <PodaciIzBaze>(); list.Add(new PodaciIzBaze("BL", SqlDateTime.Parse((DateTime.Today.AddDays(+1)).ToString()), float.MaxValue)); new ObradaPodatakaZaDB().SamoPoJednoPodrucje(list); }
/// <summary> /// 添加发文信息的方法 /// </summary> /// <param name="DocSendM">发文信息</param> /// <returns>发文信息ID</returns> public static int DocReceiveAdd(DocSendModel DocSendM) { try { #region 设置参数 SqlParameter[] param = new SqlParameter[27]; param[0] = SqlHelper.GetParameter("@CompanyCD ", DocSendM.CompanyCD); param[1] = SqlHelper.GetParameter("@DocumentNo ", DocSendM.DocumentNo); param[2] = SqlHelper.GetParameter("@SendDocTypeID ", DocSendM.SendDocTypeID); param[3] = SqlHelper.GetParameter("@SecretLevel ", DocSendM.SecretLevel); param[4] = SqlHelper.GetParameter("@EmerLevel ", DocSendM.EmerLevel); param[5] = SqlHelper.GetParameter("@SendDeptID ", DocSendM.SendDeptID); param[6] = SqlHelper.GetParameter("@FileNo ", DocSendM.FileNo); param[7] = SqlHelper.GetParameter("@FileTitle ", DocSendM.FileTitle); param[8] = SqlHelper.GetParameter("@FileDate", DocSendM.FileDate == null ? SqlDateTime.Null : SqlDateTime.Parse(DocSendM.FileDate.ToString())); param[9] = SqlHelper.GetParameter("@MainSend ", DocSendM.MainSend); param[10] = SqlHelper.GetParameter("@CCSend ", DocSendM.CCSend); param[11] = SqlHelper.GetParameter("@OutCompany ", DocSendM.OutCompany); param[12] = SqlHelper.GetParameter("@KeyWord ", DocSendM.KeyWord); param[13] = SqlHelper.GetParameter("@FileReason ", DocSendM.FileReason); param[14] = SqlHelper.GetParameter("@Description ", DocSendM.Description); param[15] = SqlHelper.GetParameter("@RegisterUserID", DocSendM.RegisterUserID); param[16] = SqlHelper.GetParameter("@Backer ", DocSendM.Backer); param[17] = SqlHelper.GetParameter("@BackerNo ", DocSendM.BackerNo); param[18] = SqlHelper.GetParameter("@BackDate", DocSendM.BackDate == null ? SqlDateTime.Null : SqlDateTime.Parse(DocSendM.BackDate.ToString())); param[19] = SqlHelper.GetParameter("@BackContent ", DocSendM.BackContent); param[20] = SqlHelper.GetParameter("@UploadDate", DocSendM.UploadDate == null ? SqlDateTime.Null : SqlDateTime.Parse(DocSendM.UploadDate.ToString())); param[21] = SqlHelper.GetParameter("@DocumentName ", DocSendM.DocumentName); param[22] = SqlHelper.GetParameter("@DocumentURL ", DocSendM.DocumentURL); param[23] = SqlHelper.GetParameter("@Remark ", DocSendM.Remark); param[24] = SqlHelper.GetParameter("@ModifiedDate", DocSendM.ModifiedDate == null ? SqlDateTime.Null : SqlDateTime.Parse(DocSendM.ModifiedDate.ToString())); param[25] = SqlHelper.GetParameter("@ModifiedUserID", DocSendM.ModifiedUserID); SqlParameter paramid = new SqlParameter("@id", SqlDbType.Int); paramid.Direction = ParameterDirection.Output; param[26] = paramid; #endregion //创建命令 SqlCommand comm = new SqlCommand(); SqlHelper.ExecuteTransStoredProcedure("officedba.insertDocSend", comm, param); int DocReceiveID = Convert.ToInt32(comm.Parameters["@id"].Value); return(DocReceiveID); } catch { return(0); } }
public void TestAUtomaticFunctionVreme() { List <PodaciIzBaze> list = new List <PodaciIzBaze>(); list.Add(new PodaciIzBaze("BL", SqlDateTime.Parse((DateTime.Today.AddDays(+1)).ToString()), 456)); new Automatik().Automatic(list); }
public void TestAUtomaticFunctionID() { List <PodaciIzBaze> list = new List <PodaciIzBaze>(); list.Add(new PodaciIzBaze(null, SqlDateTime.Parse(DateTime.Now.ToString()), 456)); new Automatik().Automatic(list); }
public void TestAUtomaticFunctionVrednost() { List <PodaciIzBaze> list = new List <PodaciIzBaze>(); list.Add(new PodaciIzBaze("BL", SqlDateTime.Parse(DateTime.Now.ToString()), float.MaxValue)); new Automatik().Automatic(list); }
/// <summary> /// 修改客户洽谈信息 /// </summary> /// <param name="CustTalkM">客户洽谈信息</param> /// <returns>bool值</returns> public static bool UpdateTalk(CustTalkModel CustTalkM) { try { StringBuilder sql = new StringBuilder(); sql.AppendLine("UPDATE officedba.CustTalk set "); sql.AppendLine("CompanyCD =@CompanyCD ,"); sql.AppendLine("CustID =@CustID ,"); sql.AppendLine("CustLinkMan =@CustLinkMan ,"); sql.AppendLine("Title =@Title ,"); sql.AppendLine("Priority =@Priority ,"); sql.AppendLine("TalkType =@TalkType ,"); sql.AppendLine("Linker =@Linker ,"); sql.AppendLine("CompleteDate =@CompleteDate ,"); sql.AppendLine("Status =@Status ,"); sql.AppendLine("Contents =@Contents ,"); sql.AppendLine("Feedback =@Feedback ,"); sql.AppendLine("Result =@Result ,"); sql.AppendLine("remark =@remark ,"); sql.AppendLine("CanViewUser = @CanViewUser, "); sql.AppendLine("CanViewUserName = @CanViewUserName, "); sql.AppendLine("ModifiedDate =@ModifiedDate ,"); sql.AppendLine("ModifiedUserID=@ModifiedUserID"); sql.AppendLine(" WHERE "); sql.AppendLine("ID = @ID "); SqlParameter[] param = new SqlParameter[18]; param[0] = SqlHelper.GetParameter("@ID ", CustTalkM.ID); param[1] = SqlHelper.GetParameter("@CompanyCD ", CustTalkM.CompanyCD); param[2] = SqlHelper.GetParameter("@CustID ", CustTalkM.CustID); param[3] = SqlHelper.GetParameter("@CustLinkMan ", CustTalkM.CustLinkMan); param[4] = SqlHelper.GetParameter("@Title ", CustTalkM.Title); param[5] = SqlHelper.GetParameter("@Priority ", CustTalkM.Priority); param[6] = SqlHelper.GetParameter("@TalkType ", CustTalkM.TalkType); param[7] = SqlHelper.GetParameter("@Linker ", CustTalkM.Linker); param[8] = SqlHelper.GetParameter("@CompleteDate", CustTalkM.CompleteDate == null ? SqlDateTime.Null : SqlDateTime.Parse(CustTalkM.CompleteDate.ToString())); param[9] = SqlHelper.GetParameter("@Status ", CustTalkM.Status); param[10] = SqlHelper.GetParameter("@Contents ", CustTalkM.Contents); param[11] = SqlHelper.GetParameter("@Feedback ", CustTalkM.Feedback); param[12] = SqlHelper.GetParameter("@Result ", CustTalkM.Result); param[13] = SqlHelper.GetParameter("@remark ", CustTalkM.remark); param[14] = SqlHelper.GetParameter("@ModifiedDate ", CustTalkM.ModifiedDate); param[15] = SqlHelper.GetParameter("@ModifiedUserID", CustTalkM.ModifiedUserID); param[16] = SqlHelper.GetParameter("@CanViewUser", CustTalkM.CanViewUser); param[17] = SqlHelper.GetParameter("@CanViewUserName", CustTalkM.CanViewUserName); SqlHelper.ExecuteTransSql(sql.ToString(), param); return(SqlHelper.Result.OprateCount > 0 ? true : false); } catch { return(false); } }
public void TestSamojednoPodrucje() { List <PodaciIzBaze> list = new List <PodaciIzBaze>(); list.Add(new PodaciIzBaze("BL", SqlDateTime.Parse(DateTime.Now.ToString()), 234)); Assert.DoesNotThrow(() => { new ObradaPodatakaZaDB().SamoPoJednoPodrucje(list); }); }
public void Index(SmsRequest incomingMessage) { WAConf wa = new WAConf(); Connector cn = new Connector(); DateTime myDateTime = DateTime.Now; string sqlFormattedDate = myDateTime.ToString("yyyy-MM-dd HH:mm:ss.fff"); cn.AddWAUser(incomingMessage.From, SqlDateTime.Parse(sqlFormattedDate)); wa.SendMessage("Your activity is now logged, Thankyou for your time", incomingMessage.From); }
/// <summary> /// 根据客户关怀ID修改关怀信息 /// </summary> /// <param name="CustLoveM">客户关怀信息</param> /// <returns>bool值</returns> public static bool UpdateLove(CustLoveModel CustLoveM) { try { StringBuilder sql = new StringBuilder(); sql.AppendLine("UPDATE officedba.CustLove set "); sql.AppendLine("CompanyCD =@CompanyCD ,"); sql.AppendLine("CustID =@CustID ,"); sql.AppendLine("CustLinkMan =@CustLinkMan ,"); //sql.AppendLine("LoveNo =@LoveNo ,"); sql.AppendLine("Title =@Title ,"); sql.AppendLine("LoveType =@LoveType ,"); sql.AppendLine("Contents =@Contents ,"); sql.AppendLine("Linker =@Linker ,"); sql.AppendLine("LoveDate =@LoveDate ,"); sql.AppendLine("Feedback =@Feedback ,"); sql.AppendLine("remarks =@remarks ,"); sql.AppendLine("CanViewUser = @CanViewUser, "); sql.AppendLine("CanViewUserName = @CanViewUserName, "); sql.AppendLine("ModifiedDate =@ModifiedDate ,"); sql.AppendLine("ModifiedUserID=@ModifiedUserID"); sql.AppendLine(" WHERE "); sql.AppendLine("ID = @ID "); SqlParameter[] param = new SqlParameter[15]; param[0] = SqlHelper.GetParameter("@ID ", CustLoveM.ID); param[1] = SqlHelper.GetParameter("@CompanyCD ", CustLoveM.CompanyCD); param[2] = SqlHelper.GetParameter("@CustID ", CustLoveM.CustID); param[3] = SqlHelper.GetParameter("@CustLinkMan ", CustLoveM.CustLinkMan); //param[4] = SqlHelper.GetParameter("@LoveNo ",CustLoveM.LoveNo ); param[4] = SqlHelper.GetParameter("@Title ", CustLoveM.Title); param[5] = SqlHelper.GetParameter("@LoveType ", CustLoveM.LoveType); param[6] = SqlHelper.GetParameter("@Contents ", CustLoveM.Contents); param[7] = SqlHelper.GetParameter("@Linker ", CustLoveM.Linker); param[8] = SqlHelper.GetParameter("@LoveDate", CustLoveM.LoveDate == null ? SqlDateTime.Null : SqlDateTime.Parse(CustLoveM.LoveDate.ToString())); param[9] = SqlHelper.GetParameter("@Feedback ", CustLoveM.Feedback); param[10] = SqlHelper.GetParameter("@remarks ", CustLoveM.remarks); param[11] = SqlHelper.GetParameter("@ModifiedDate", CustLoveM.ModifiedDate == null ? SqlDateTime.Null : SqlDateTime.Parse(CustLoveM.ModifiedDate.ToString())); param[12] = SqlHelper.GetParameter("@ModifiedUserID", CustLoveM.ModifiedUserID); param[13] = SqlHelper.GetParameter("@CanViewUser", CustLoveM.CanViewUser); param[14] = SqlHelper.GetParameter("@CanViewUserName", CustLoveM.CanViewUserName); SqlHelper.ExecuteTransSql(sql.ToString(), param); return(SqlHelper.Result.OprateCount > 0 ? true : false); } catch { return(false); } }
public void TestAUtomaticFunction() { List <PodaciIzBaze> list = new List <PodaciIzBaze>(); list.Add(new PodaciIzBaze("BL", SqlDateTime.Parse(DateTime.Now.ToString()), 456)); Assert.DoesNotThrow(() => { new Automatik().Automatic(list); }); }
/// <summary> /// Método de validação de campos data para ser usado em Validators. /// </summary> /// <param name="source"></param> /// <param name="args"></param> protected void ValidarData_ServerValidate(object source, ServerValidateEventArgs args) { try { SqlDateTime d = SqlDateTime.Parse(DateTime.Parse(args.Value).ToString("MM/dd/yyyy")); args.IsValid = true; } catch { args.IsValid = false; } }
/////////////////////////////////////////WAUSERS//////////////////////////////////////////////////// public List <WAUser> GetWAUsers() { DataHandler dh = new DataHandler(); DataTable dt = dh.Read("tblWAUsers"); List <WAUser> users = new List <WAUser>(); foreach (DataRow row in dt.Rows) { users.Add(new WAUser(row[1].ToString(), SqlDateTime.Parse(row[2].ToString()))); } return(users); }
public static bool InsertProviderContactHistory(ProviderContactHistoryModel model, out string ID) { ArrayList listADD = new ArrayList(); bool result = false; ID = "0"; #region 采购供应商联络添加SQL语句 StringBuilder sqlArrive = new StringBuilder(); sqlArrive.AppendLine("INSERT INTO officedba.ProviderContactHistory"); sqlArrive.AppendLine("(CompanyCD,CustID,ContactNo,Title,LinkManID,LinkManName,LinkReasonID,LinkMode,LinkDate,Linker,Contents)"); sqlArrive.AppendLine("VALUES (@CompanyCD,@CustID,@ContactNo,@Title,@LinkManID,@LinkManName,@LinkReasonID,@LinkMode,@LinkDate,@Linker,@Contents)"); sqlArrive.AppendLine("set @ID=@@IDENTITY"); SqlCommand comm = new SqlCommand(); comm.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", model.CompanyCD)); comm.Parameters.Add(SqlHelper.GetParameter("@CustID", model.CustID)); comm.Parameters.Add(SqlHelper.GetParameter("@ContactNo", model.ContactNo)); comm.Parameters.Add(SqlHelper.GetParameter("@Title", model.Title)); comm.Parameters.Add(SqlHelper.GetParameter("@LinkManID", model.LinkManID)); comm.Parameters.Add(SqlHelper.GetParameter("@LinkManName", model.LinkManName)); comm.Parameters.Add(SqlHelper.GetParameter("@LinkReasonID", model.LinkReasonID)); comm.Parameters.Add(SqlHelper.GetParameter("@LinkMode", model.LinkMode)); comm.Parameters.Add(SqlHelper.GetParameter("@LinkDate", model.LinkDate == null ? SqlDateTime.Null : SqlDateTime.Parse(model.LinkDate.ToString()))); comm.Parameters.Add(SqlHelper.GetParameter("@Linker", model.Linker)); comm.Parameters.Add(SqlHelper.GetParameter("@Contents", model.Contents)); comm.Parameters.Add(SqlHelper.GetOutputParameter("@ID", SqlDbType.Int)); comm.CommandText = sqlArrive.ToString(); listADD.Add(comm); #endregion try { if (SqlHelper.ExecuteTransWithArrayList(listADD)) { ID = comm.Parameters["@ID"].Value.ToString(); result = true; } return(result); } catch (Exception ex) { throw ex; } }
public static List <string> InsertIntoTable(List <Dictionary <Tuple <int, string>, Tuple <DateTime, float> > > listaUbacenihVrednostiWhile) { //string unosUBazu = "INSERT INTO FunkcijaMaximum (IDGeoPodrucja, VremeProracuna, MaximalnaVrednost, PoslednjeVreme) VALUES ('DO', '2018-05-31 14:12:12.000', 234, '2018-05-31 12:31:56.000')"; List <string> retVal = new List <string>(); //Konekcija k = new Konekcija(); //Vraca redove iz tabele sa danasnjim datumom i sortira listu po opadajucem redoslijedu //var movies = _db.Movies.OrderBy(c => c.Category).ThenBy(n => n.Name) List <PodaciIzBaze> traziDatum = Program.proxyDanasnji.DanasnjiDatum().OrderByDescending(o => o.ID).ThenBy(n => n.Vreme).ToList(); List <PodaciIzBaze> traziNajnovijiDatum = SamoPoJednoPodrucje(traziDatum); foreach (var itemDatum in traziNajnovijiDatum) { foreach (var itemLista in listaUbacenihVrednostiWhile) { foreach (var itemDict in itemLista) { if (itemDict.Key.Item1 == 1 && itemDatum.ID == itemDict.Key.Item2 && (ProveriZaIf(itemDict.Key.Item2, SqlDateTime.Parse(itemDatum.Vreme.ToString()), itemDict.Key.Item1))) { retVal.Add("INSERT INTO FunkcijaAverage (IDGeoPodrucja, VremeProracuna, AverageVrednost, PoslednjeVreme) " + "VALUES ('" + itemDict.Key.Item2 + "'," + "'" + SqlDateTime.Parse(itemDict.Value.Item1.ToString()) + "'," + itemDict.Value.Item2 + "," + "'" + SqlDateTime.Parse(itemDatum.Vreme.ToString()) + "')"); } else if (itemDict.Key.Item1 == 2 && itemDatum.ID == itemDict.Key.Item2 && (ProveriZaIf(itemDict.Key.Item2, SqlDateTime.Parse(itemDatum.Vreme.ToString()), itemDict.Key.Item1))) { retVal.Add("INSERT INTO FunkcijaMaximum (IDGeoPodrucja, VremeProracuna, MaximalnaVrednost, PoslednjeVreme) " + "VALUES ('" + itemDict.Key.Item2 + "'," + "'" + SqlDateTime.Parse(itemDict.Value.Item1.ToString()) + "'," + itemDict.Value.Item2 + "," + "'" + SqlDateTime.Parse(itemDatum.Vreme.ToString()) + "')"); } else if (itemDict.Key.Item1 == 3 && itemDatum.ID == itemDict.Key.Item2 && (ProveriZaIf(itemDict.Key.Item2, SqlDateTime.Parse(itemDatum.Vreme.ToString()), itemDict.Key.Item1))) { retVal.Add("INSERT INTO FunkcijaMinimum (IDGeoPodrucja, VremeProracuna, MinimalnaVrednost, PoslednjeVreme) " + "VALUES ('" + itemDict.Key.Item2 + "'," + "'" + SqlDateTime.Parse(itemDict.Value.Item1.ToString()) + "'," + itemDict.Value.Item2 + "," + "'" + SqlDateTime.Parse(itemDatum.Vreme.ToString()) + "')"); } } } } return(retVal); //throw new NotImplementedException(); }
/// <summary> /// 添加会议通知的方法 /// </summary> /// <param name="MeetingInfoM">会议通知信息</param> /// <returns>被添加会议通知ID</returns> public static int MeetingInfoAdd(MeetingInfoModel MeetingInfoM) { try { #region 设置参数 SqlParameter[] param = new SqlParameter[25]; param[0] = SqlHelper.GetParameter("@CompanyCD ", MeetingInfoM.CompanyCD); param[1] = SqlHelper.GetParameter("@MeetingNo ", MeetingInfoM.MeetingNo); param[2] = SqlHelper.GetParameter("@Title ", MeetingInfoM.Title); param[3] = SqlHelper.GetParameter("@TypeID ", MeetingInfoM.TypeID); param[4] = SqlHelper.GetParameter("@Caller ", MeetingInfoM.Caller); param[5] = SqlHelper.GetParameter("@DeptID ", MeetingInfoM.DeptID); param[6] = SqlHelper.GetParameter("@Chairman ", MeetingInfoM.Chairman); param[7] = SqlHelper.GetParameter("@StartDate", MeetingInfoM.StartDate == null ? SqlDateTime.Null : SqlDateTime.Parse(MeetingInfoM.StartDate.ToString())); param[8] = SqlHelper.GetParameter("@StartTime ", MeetingInfoM.StartTime); param[9] = SqlHelper.GetParameter("@TimeLong ", MeetingInfoM.TimeLong); param[10] = SqlHelper.GetParameter("@Place ", MeetingInfoM.Place); param[11] = SqlHelper.GetParameter("@Topic ", MeetingInfoM.Topic); param[12] = SqlHelper.GetParameter("@Contents ", MeetingInfoM.Contents); param[13] = SqlHelper.GetParameter("@ReadyInfo ", MeetingInfoM.ReadyInfo); param[14] = SqlHelper.GetParameter("@Attachment ", MeetingInfoM.Attachment); param[15] = SqlHelper.GetParameter("@Remark ", MeetingInfoM.Remark); param[16] = SqlHelper.GetParameter("@MeetingStatus ", MeetingInfoM.MeetingStatus); param[17] = SqlHelper.GetParameter("@IsMobileCall ", MeetingInfoM.IsMobileCall); param[18] = SqlHelper.GetParameter("@CallContent ", MeetingInfoM.CallContent); param[19] = SqlHelper.GetParameter("@JoinUser ", MeetingInfoM.JoinUser); param[20] = SqlHelper.GetParameter("@Sender ", MeetingInfoM.Sender); param[21] = SqlHelper.GetParameter("@SendDate", MeetingInfoM.SendDate == null ? SqlDateTime.Null : SqlDateTime.Parse(MeetingInfoM.SendDate.ToString())); param[22] = SqlHelper.GetParameter("@ModifiedDate ", MeetingInfoM.ModifiedDate); param[23] = SqlHelper.GetParameter("@ModifiedUserID", MeetingInfoM.ModifiedUserID); SqlParameter paramid = new SqlParameter("@id", SqlDbType.Int); paramid.Direction = ParameterDirection.Output; param[24] = paramid; #endregion //创建命令 SqlCommand comm = new SqlCommand(); SqlHelper.ExecuteTransStoredProcedure("officedba.insertMeetingInfo", comm, param); int MeetingInfoID = Convert.ToInt32(comm.Parameters["@id"].Value); return(MeetingInfoID); } catch { return(0); } }
private static void Binary(Func <SqlDateTimeType, Func <ISqlValue, ISqlValue, SqlBoolean> > selector, string date1, string date2, bool expected) { var type = new SqlDateTimeType(SqlTypeCode.DateTime); var sqlDate1 = SqlDateTime.Parse(date1); var sqlDate2 = SqlDateTime.Parse(date2); var op = selector(type); var result = op(sqlDate1, sqlDate2); var expectedResult = (SqlBoolean)expected; Assert.Equal(expectedResult, result); }
private static void BinaryWithInterval(Func <SqlDateTimeType, Func <ISqlValue, ISqlValue, ISqlValue> > selector, string date, string offset, string expected) { var type = new SqlDateTimeType(SqlTypeCode.DateTime); var sqlDate = SqlDateTime.Parse(date); var dts = SqlDayToSecond.Parse(offset); var op = selector(type); var result = op(sqlDate, dts); var expectedResult = SqlDateTime.Parse(expected); Assert.Equal(expectedResult, result); }
private static void BinaryWithInterval(Func <SqlDateTimeType, Func <ISqlValue, ISqlValue, ISqlValue> > selector, string date, int months, string expected) { var type = new SqlDateTimeType(SqlTypeCode.DateTime); var sqlDate = SqlDateTime.Parse(date); var ytm = new SqlYearToMonth(months); var op = selector(type); var result = op(sqlDate, ytm); var expectedResult = SqlDateTime.Parse(expected); Assert.Equal(expectedResult, result); }
/// <summary> /// Effettua un try parse come DateTime.TryParse per SqlDateTime /// </summary> /// <param name="sqlDataString">SqlDateTime in formato stringa</param> /// <param name="sqlDateTime">parametro in out da valorizzare, in caso di errore sqlDateTime viene valorizzato con SqlDateTime.MinValue</param> /// <returns>true se il Parse è andato a buon fine, false altrimenti</returns> public static bool TryParse(this string sqlDataString, out SqlDateTime sqlDateTime) { try { sqlDateTime = SqlDateTime.Parse(sqlDataString); } catch (Exception) { sqlDateTime = SqlDateTime.MinValue; } return(true); }
public static bool UpdateProviderContactHistory(ProviderContactHistoryModel model) { if (model.ID <= 0) { return(false); } ArrayList listADD = new ArrayList(); bool result = false; #region 修改供应商联络 StringBuilder sqlArrive = new StringBuilder(); sqlArrive.AppendLine("Update Officedba.ProviderContactHistory set CompanyCD=@CompanyCD,"); sqlArrive.AppendLine("CustID=@CustID,ContactNo=@ContactNo,Title=@Title,LinkManID=@LinkManID,LinkManName=@LinkManName,LinkReasonID=@LinkReasonID,"); sqlArrive.AppendLine("LinkMode=@LinkMode,LinkDate=@LinkDate,Linker=@Linker,Contents=@Contents where CompanyCD=@CompanyCD and ID=@ID"); SqlCommand comm = new SqlCommand(); comm.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", model.CompanyCD)); comm.Parameters.Add(SqlHelper.GetParameter("@CustID", model.CustID)); comm.Parameters.Add(SqlHelper.GetParameter("@ContactNo", model.ContactNo)); comm.Parameters.Add(SqlHelper.GetParameter("@Title", model.Title)); comm.Parameters.Add(SqlHelper.GetParameter("@LinkManID", model.LinkManID)); comm.Parameters.Add(SqlHelper.GetParameter("@LinkManName", model.LinkManName)); comm.Parameters.Add(SqlHelper.GetParameter("@LinkReasonID", model.LinkReasonID)); comm.Parameters.Add(SqlHelper.GetParameter("@LinkMode", model.LinkMode)); comm.Parameters.Add(SqlHelper.GetParameter("@LinkDate", model.LinkDate == null ? SqlDateTime.Null : SqlDateTime.Parse(model.LinkDate.ToString()))); comm.Parameters.Add(SqlHelper.GetParameter("@Linker", model.Linker)); comm.Parameters.Add(SqlHelper.GetParameter("@Contents", model.Contents)); comm.Parameters.Add(SqlHelper.GetParameter("@ID", model.ID)); comm.CommandText = sqlArrive.ToString(); listADD.Add(comm); #endregion try { if (SqlHelper.ExecuteTransWithArrayList(listADD)) { result = true; } return(result); } catch (Exception ex) { throw ex; } }
public void TestGetVrijednostiZaGeoPodrucje() { List <PodaciIzBaze> podaci = new List <PodaciIzBaze>() { new PodaciIzBaze("BL", SqlDateTime.Parse(DateTime.Now.ToString()), 1234), new PodaciIzBaze("BN", SqlDateTime.Parse(DateTime.Now.ToString()), 1238), new PodaciIzBaze("SA", SqlDateTime.Parse(DateTime.Now.ToString()), 1236), }; Assert.DoesNotThrow(() => { new GetValues().GetVrijednostiZaGeoPodrucje(podaci); }); }
protected void btnSave_Click(object sender, EventArgs e) { try { Rates rate = new Rates(); rate.RateType = SqlInt32.Parse(drpRateTypesList.SelectedValue); rate.RateDescription_EN = txtRateNameEn.Text; rate.RateDescription_AR = txtRateNameAr.Text; rate.FromDate = SqlDateTime.Parse(txtFromDate.Text); rate.ToDate = SqlDateTime.Parse(txtToDate.Text); rate.Rate = SqlMoney.Parse(txtRate.Text); if (rate.FromDate > rate.ToDate) { lblMsg.Text = "From Date cannot be after To Date "; lblMsg.ForeColor = Color.Red; return; } rate.LastModifiedUser = 1; rate.LastModifiedDate = SqlDateTime.Parse(DateTime.Now.ToString()); bool retval = false; if (Session["Prop_Action"] == "U") { rate.Rate_ID = Int32.Parse(hidRateId.Value); retval = rate.Update(); } else { rate.CreatedUser = 1; rate.CreatedDate = rate.LastModifiedDate; retval = rate.Insert(); } lblMsg.Text = "Data Saved successfully."; lblMsg.ForeColor = Color.Green; if (retval) { Response.Redirect("RatesList.aspx", true); } else { lblMsg.Text = rate.ErrorDesc.ToString(); } } catch (Exception ex) { lblMsg.Text = "Data not Saved ."; lblMsg.ForeColor = Color.Red; } }
/// <summary> /// 添加请示信息的方法 /// </summary> /// <param name="DocSendM">请示信息</param> /// <returns>请示信息ID</returns> public static int DocRequstAdd(DocRequstModel DocRequstM) { try { #region 设置参数 SqlParameter[] param = new SqlParameter[20]; param[0] = SqlHelper.GetParameter("@CompanyCD ", DocRequstM.CompanyCD); param[1] = SqlHelper.GetParameter("@DocumentNo ", DocRequstM.DocumentNo); param[2] = SqlHelper.GetParameter("@RequstDocType ", DocRequstM.RequstDocType); param[3] = SqlHelper.GetParameter("@SecretLevel ", DocRequstM.SecretLevel); param[4] = SqlHelper.GetParameter("@EmerLevel ", DocRequstM.EmerLevel); param[5] = SqlHelper.GetParameter("@Main ", DocRequstM.Main); param[6] = SqlHelper.GetParameter("@RequestMoney ", DocRequstM.RequestMoney); param[7] = SqlHelper.GetParameter("@RequestTitle ", DocRequstM.RequestTitle); param[8] = SqlHelper.GetParameter("@Description ", DocRequstM.Description); param[9] = SqlHelper.GetParameter("@RequstNo ", DocRequstM.RequstNo); param[10] = SqlHelper.GetParameter("@RequestDate", DocRequstM.RequestDate == null ? SqlDateTime.Null : SqlDateTime.Parse(DocRequstM.RequestDate.ToString())); param[11] = SqlHelper.GetParameter("@RequestDept ", DocRequstM.RequestDept); param[12] = SqlHelper.GetParameter("@EmployeeID ", DocRequstM.EmployeeID); param[13] = SqlHelper.GetParameter("@UploadUserID ", DocRequstM.UploadUserID); param[14] = SqlHelper.GetParameter("@UploadDate", DocRequstM.UploadDate == null ? SqlDateTime.Null : SqlDateTime.Parse(DocRequstM.UploadDate.ToString())); param[15] = SqlHelper.GetParameter("@DocumentName ", DocRequstM.DocumentName); param[16] = SqlHelper.GetParameter("@DocumentURL ", DocRequstM.DocumentURL); param[17] = SqlHelper.GetParameter("@ModifiedDate", DocRequstM.ModifiedDate == null ? SqlDateTime.Null : SqlDateTime.Parse(DocRequstM.ModifiedDate.ToString())); param[18] = SqlHelper.GetParameter("@ModifiedUserID", DocRequstM.ModifiedUserID); SqlParameter paramid = new SqlParameter("@id", SqlDbType.Int); paramid.Direction = ParameterDirection.Output; param[19] = paramid; #endregion //创建命令 SqlCommand comm = new SqlCommand(); SqlHelper.ExecuteTransStoredProcedure("officedba.insertDocRequst", comm, param); int DocRequstID = Convert.ToInt32(comm.Parameters["@id"].Value); return(DocRequstID); } catch { return(0); } }