public static DataTable BindData()
{
DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection(@"Data Source=PBGIANG;Initial Catalog=NHOM3;Integrated Security=True");
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
DateInstance dateInstance = (DateInstance)HttpContext.Current.Session["DateG"];
if (dateInstance != null)
{
if (dateInstance.DateID > 2)
{
cmd.CommandText = "thongkeDonHang2Date";
cmd.Parameters.Add("@ngay1", SqlDbType.Date).Value = getDate().DateValue;
cmd.Parameters.Add("@ngay2", SqlDbType.Date).Value = DateTime.Now;
}
else
{
cmd.CommandText = "thongkeDonHang";
cmd.Parameters.Add("@ngay", SqlDbType.Date).Value = getDate().DateValue;
}
}
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
dt = ds.Tables[0];
conn.Close();
return(dt);
}
public void TrimAuditLog(DateInstance deleteEndDate)
{
if (deleteEndDate == null)
{
throw new JavaScriptException(this.Engine, "Error", "deleteEndDate must be specified.");
}
m_audit.TrimAuditLog(deleteEndDate.Value);
}
public int DeleteEntries(DateInstance deleteEndDate)
{
if (deleteEndDate == null)
{
throw new JavaScriptException(this.Engine, "Error", "deleteEndDate must be specified.");
}
return(m_audit.DeleteEntries(deleteEndDate.Value));
}
public void ScheduleEnd(DateInstance endDate)
{
if (endDate == null)
{
throw new JavaScriptException(Engine, "Error", "endDate argument must be supplied.");
}
m_file.ScheduleEnd(endDate.Value);
}
public void SetRangeStart(DateInstance start)
{
if (start == null)
{
throw new JavaScriptException(this.Engine, "Error", "Start date must be specified.");
}
m_auditQuery.SetRangeStart(start.Value);
}
public void SetRangeEnd(DateInstance end)
{
if (end == null)
{
throw new JavaScriptException(this.Engine, "Error", "End date must be specified.");
}
m_auditQuery.SetRangeEnd(end.Value);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
drpDate.DataSource = DateInstance.getListDate();
drpDate.DataValueField = "DateValue";
drpDate.DataTextField = "Name";
drpDate.DataBind();
}
}
public static double Utc(ScriptEngine engine, int year, int month, [DefaultParameterValue(1)] object dayArg, [DefaultParameterValue(0)] object hourArg,
[DefaultParameterValue(0)] object minuteArg, [DefaultParameterValue(0)] object secondArg, [DefaultParameterValue(0)] object millisecondArg)
{
var day = JurassicHelper.GetTypedArgumentValue(engine, dayArg, 1);
var hour = JurassicHelper.GetTypedArgumentValue(engine, hourArg, 0);
var minute = JurassicHelper.GetTypedArgumentValue(engine, minuteArg, 0);
var second = JurassicHelper.GetTypedArgumentValue(engine, secondArg, 0);
var millisecond = JurassicHelper.GetTypedArgumentValue(engine, millisecondArg, 0);
return(DateInstance.Utc(engine, year, month, day, hour, minute, second, millisecond));
}
public void ShouldBeADate()
{
var value = new DateInstance(_engine);
Assert.Equal(false, value.IsBoolean());
Assert.Equal(false, value.IsArray());
Assert.Equal(true, value.IsDate());
Assert.Equal(false, value.IsNull());
Assert.Equal(false, value.IsNumber());
Assert.Equal(true, value.IsObject());
Assert.Equal(false, value.IsPrimitive());
Assert.Equal(false, value.IsRegExp());
Assert.Equal(false, value.IsString());
Assert.Equal(false, value.IsUndefined());
Assert.Equal(true, value.AsDate() != null);
}
public void ScheduleStart(DateInstance startDate, object setModerationStatus, object approvalComment)
{
if (startDate == null)
{
throw new JavaScriptException(Engine, "Error", "startDate argument must be supplied.");
}
if (setModerationStatus == Undefined.Value)
{
m_file.ScheduleStart(startDate.Value);
return;
}
if (approvalComment == Undefined.Value)
{
m_file.ScheduleStart(startDate.Value, TypeConverter.ToBoolean(setModerationStatus));
return;
}
m_file.ScheduleStart(startDate.Value, TypeConverter.ToBoolean(setModerationStatus), TypeConverter.ToString(approvalComment));
}
protected void drpDate_SelectedIndexChanged(object sender, EventArgs e)
{
DateInstance [] data2 = DateInstance.getListDate().ToArray();
DateInstance dateInstance = null;
for (int i = 0; i < data2.Length; i++)
{
if (i == drpDate.SelectedIndex)
{
dateInstance = data2[i];
break;
}
}
if (dateInstance == null)
{
dateInstance = new DateInstance(1, "Hôm nay", DateTime.Now);
}
if (HttpContext.Current.Session["dateg"] != null)
{
HttpContext.Current.Session["dateg"] = dateInstance;
}
}
public SPFileInstance Add(params object[] args)
{
var urlOfFile = TypeConverter.ToString(args.GetValue <object>(0));
var file = args.GetValue <Base64EncodedByteArrayInstance>(1);
var properties = args.GetValue <object>(2);
var createdBy = args.GetValue <object>(3);
var modifiedBy = args.GetValue <object>(4);
var timeCreated = args.GetValue <object>(5);
var timeLastModified = args.GetValue <object>(6);
var checkInComment = args.GetValue <object>(7);
var overwrite = args.GetValue <object>(8);
var requireWebFilePermissions = args.GetValue <object>(9);
if (urlOfFile.IsNullOrWhiteSpace())
{
throw new JavaScriptException(this.Engine, "Error", "File Url must be specified as the first parameter.");
}
if (file == null)
{
throw new JavaScriptException(this.Engine, "Error", "File Url must be specified as the first parameter.");
}
Hashtable htProperties = null;
if (properties is HashtableInstance)
{
htProperties = (properties as HashtableInstance).Hashtable;
}
else if (properties != null && properties != Null.Value && properties != Undefined.Value)
{
htProperties = SPHelper.GetFieldValuesHashtableFromPropertyObject(properties);
}
var uCreatedBy = SPBaristaContext.Current.Web.CurrentUser;
if (createdBy is SPUserInstance)
{
uCreatedBy = (createdBy as SPUserInstance).User;
}
var uModifiedBy = SPBaristaContext.Current.Web.CurrentUser;
if (modifiedBy is SPUserInstance)
{
uModifiedBy = (modifiedBy as SPUserInstance).User;
}
var dtTimeCreated = DateTime.UtcNow;
if (timeCreated is DateInstance)
{
dtTimeCreated = (timeCreated as DateInstance).Value;
}
else if (timeCreated != null && timeCreated != Null.Value && timeCreated != Undefined.Value)
{
dtTimeCreated = new DateInstance(this.Engine.Object.InstancePrototype, DateInstance.Parse(TypeConverter.ToString(timeCreated))).Value;
}
var dtTimeLastModified = DateTime.UtcNow;
if (timeLastModified is DateInstance)
{
dtTimeLastModified = (timeLastModified as DateInstance).Value;
}
else if (timeLastModified != null && timeLastModified != Null.Value && timeLastModified != Undefined.Value)
{
dtTimeLastModified = new DateInstance(this.Engine.Object.InstancePrototype, DateInstance.Parse(TypeConverter.ToString(timeLastModified))).Value;
}
string strCheckInComment = null;
if (checkInComment != null && checkInComment != Null.Value && checkInComment != Undefined.Value)
{
strCheckInComment = TypeConverter.ToString(checkInComment);
}
var bOverwrite = false;
if (overwrite != null && overwrite != Null.Value && overwrite != Undefined.Value)
{
bOverwrite = TypeConverter.ToBoolean(overwrite);
}
var bRequireWebFilePermissions = false;
if (requireWebFilePermissions != null && requireWebFilePermissions != Null.Value && requireWebFilePermissions != Undefined.Value)
{
bRequireWebFilePermissions = TypeConverter.ToBoolean(requireWebFilePermissions);
}
using (var ms = new MemoryStream(file.Data))
{
var result = m_fileCollection.Add(urlOfFile, ms, htProperties, uCreatedBy, uModifiedBy, dtTimeCreated, dtTimeLastModified, strCheckInComment, bOverwrite, bRequireWebFilePermissions);
return(result == null
? null
: new SPFileInstance(this.Engine.Object.InstancePrototype, result));
}
}
public static double Parse(string dateStr)
{
return(DateInstance.Parse(dateStr));
}
public static double Now()
{
return(DateInstance.Now());
}
