public int InsertIndent(indent indent)
{
string sql = "insert into indent(start_time,end_time,user_id,indent_state,indent_date,indent_price)values(@start_time,@end_time,@user_id,@indent_state,@indent_date,@indent_price)";
SqlParameter[] sp =
{
new SqlParameter("@start_time", indent.start_time),
new SqlParameter("@end_time", indent.end_time),
new SqlParameter("@user_id", indent.user_id),
new SqlParameter("@indent_state", indent.indent_state),
new SqlParameter("@indent_date", indent.indent_date),
new SqlParameter("@indent_price", indent.indent_price),
};
return(DBHelper.GetExcuteNonQuery(sql, sp));
}
public void rent(object sender, EventArgs e)
{
if (Session["user_id"] != null)
{
string st = Session["datebegin"].ToString();
string ed = Session["dateend"].ToString();
if (st == "" || ed == "")
{
Response.Write("<script>alert('请输入开始结束日期')</script>");
}
else
{
Button btn = (Button)sender;
Label gprice = btn.Parent.FindControl("gprice") as Label;
string str = gprice.Attributes["data-value"].ToString();
indent ind = new indent();
ind.user_id = (int)Session["user_id"];
DateTime start = Convert.ToDateTime(Session["datebegin"].ToString());
ind.start_time = start;
DateTime end = Convert.ToDateTime(Session["dateend"].ToString());
ind.end_time = end;
ind.indent_date = DateTime.Now;
ind.indent_state = "已租用";
ind.indent_price = float.Parse(str);
int i = IndentManager.InsertIndent(ind);
if (i == 1)
{
Response.Write("<script>alert('租车成功，可到个人中心页面查看')</script>");
}
}
}
else
{
Response.Write("<script>alert('请先登录网站')</script>");
}
}
public static int GetIndent(indent hps)
{
string sql = "update indent set indent_name= @indent_name,indent_phone=@indent_phone,indent_mail=@indent_mail,indent_site=@indent_site where id =@id";
return(DAL.SqlHelper <Model.indent> .ExceuteNonQuery(sql, hps));
}
message.WithLeadingTrivia(Whitespace("")) !.WithIndentation(indent: indent)
public static int AddIndents(indent sIndent)
{
return(DAL.SqlHelper <indent> .ExceuteNonQuery("insert into indent(indent_name,indent_phone,product_id,indent_mail,indent_site)values(@indent_name,@indent_phone,@product_id,@indent_mail,@indent_site)", model : sIndent));
}
public static indent GetIndent(indent indent)
{
string sql = "select * from indent where id = @id";
return(DAL.SqlHelper <Model.indent> .Query(sql, indent)[0]);
}
=> GetArrayProperty(name, items, indent, formatNameAsCamelCase, stringBuilder.AppendIndentedLine(indent, appendComma));
public static int InsertIndent(indent indent)
{
return(i.InsertIndent(indent));
}
