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);
}
}
