/// <summary>
/// 用于财务流水
/// </summary>
/// <param name="searchtype">搜索类型 1:按userid检索,2:按UserName检索</param>
/// <returns></returns>
public DataTable SelByType(SType stype, int searchtype = 1, string search = "")
{
string strwhere = "1=1 ";
if (!string.IsNullOrEmpty(search))
{
if (searchtype == 1 && DataConvert.CLng(search) > 0)
{
strwhere += " AND A.UserID=" + Convert.ToInt32(search);
search = DataConverter.CLng(search).ToString();
}
else
{
strwhere += " AND UserName LIKE @search";
search = "%" + search + "%";
}
}
SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@search", "%" + search + "%") };
string tbname = GetTbName(stype);
return(DBCenter.JoinQuery("A.*,B.UserName", tbname, "ZL_User", "A.UserID=B.UserID", strwhere, "A.HisTime DESC", sp));
}
public void SetModel(string primaryKey, string formMode, EntryModel model)
{
model.ApproveTableName = "AssetsMaintain";
model.ApprovePkField = "assetsMaintainId";
if (formMode != "new" && formMode != "new2")
{
Dictionary <string, object> paras = new Dictionary <string, object>();
paras.Add("assetsMaintainId", primaryKey);
string sql = @"select AssetsMaintain.assetsMaintainNo,
AssetsMaintain.assetsMaintainName ,
AssetsMaintainDetail.maintainDate
from AssetsMaintain,AssetsMaintainDetail
where AssetsMaintain.assetsMaintainId=AssetsMaintainDetail.assetsMaintainId
and AssetsMaintain.assetsMaintainId=@assetsMaintainId";
DataTable dtGrid = AppMember.DbHelper.GetDataSet(sql, paras).Tables[0];
DataRow dr = dtGrid.Rows[0];
model.AssetsMaintainId = primaryKey;
model.AssetsMaintainNo = DataConvert.ToString(dr["assetsMaintainNo"]);
model.AssetsMaintainName = DataConvert.ToString(dr["assetsMaintainName"]);
model.MaintainDate = DataConvert.ToDateTime(dr["maintainDate"]);
}
}
public Asiento GetById(int id)
{
Asiento objAsiento = null;
String sql = "SELECT * FROM TH_Asiento A INNER JOIN TH_Zona Z ON Z.IdZona = A.IdZona INNER JOIN TH_TEATRO T ON T.IdTeatro = Z.IdTeatro WHERE IdAsiento = @codigo ";
OleDbParameter codigo = UtilDA.SetParameters("@codigo", OleDbType.Integer, id);
using (var dtr = UtilDA.ExecuteReader(cmd, CommandType.Text, sql, cnx, codigo))
{
objAsiento = new Asiento();
objAsiento.IdAsiento = DataConvert.ToInt(dtr["IdAsiento"]);
objAsiento.Descripcion = DataConvert.ToString(dtr["A.Descripcion"]);
objAsiento.Fila = DataConvert.ToString(dtr["Fila"]);
objAsiento.FechaCreacion = DataConvert.ToDateTime(dtr["FechaCrea"]);
objAsiento.UsuarioCreacion = DataConvert.ToString(dtr["UserCrea"]);
objAsiento.FechaModificacion = DataConvert.ToDateTime(dtr["FechaMod"]);
objAsiento.UsuarioModificacion = DataConvert.ToString(dtr["UserMod"]);
}
UtilDA.Close(cnx);
return(objAsiento);
}
public ActionResult Index()
{
M_CommonData storeMod = conBll.SelMyStore(mu.UserName);
if (storeMod == null)
{
return(RedirectToAction("StoreApply")); //申请店铺
}
else if (storeMod.Status != 99) //等待审核
{
return(RedirectToAction("StoreEdit"));
}
else
{
DataTable cmdinfo = conBll.GetContent(storeMod.GeneralID);
if (cmdinfo.Rows.Count < 1)
{
function.WriteErrMsg("店铺信息不完整"); return(Content(""));
}
DataRow dr = cmdinfo.Rows[0];
//DataTable sstDT = sstbll.GetStyleByModel(Convert.ToInt32(dr["StoreModelID"]), 1);
//M_StoreStyleTable sst = sstbll.GetStyleByID(Convert.ToInt32(dr["StoreStyleID"]));
//ViewBag.sstdp = MVCHelper.ToSelectList(sstDT, "StyleName", "ID", dr["StoreStyleID"].ToString());
ViewBag.dr = dr;
//ViewBag.sstimg = sst == null ? "" : function.GetImgUrl(sst.StylePic);
ViewBag.modelhtml = fieldBll.InputallHtml(DataConvert.CLng(dr["StoreModelID"]), 0, new ModelConfig()
{
ValueDT = cmdinfo
});
}
DataTable styleDt = styleBll.Sel();
styleDt.Columns["ID"].ColumnName = "TemplateID";
styleDt.Columns["Template_Index"].ColumnName = "TemplateUrl";
styleDt.Columns["Thumbnail"].ColumnName = "TemplatePic";
styleDt.Columns["StyleName"].ColumnName = "rname";
ViewBag.styleDt = styleDt;
return(View(storeMod));
}
private static Setting.Setting.UserAgentStruct ReadUserAgentNode(XmlNode child)
{
//初始化一下userAgent
Setting.Setting.UserAgentStruct userAgent = new Setting.Setting.UserAgentStruct();
userAgent.Selected = new KeyValuePair <string, string>();
userAgent.UserAgentList = new Dictionary <string, string>();
foreach (XmlNode c in child.ChildNodes)
{
if (c.Name == "type")
{
userAgent.IsRandom = DataConvert.StrToBool(c.InnerText);
}
else if (c.Name == "option")
{
//判断name属性是否存在
if (c.Attributes["name"] == null)
{
continue;
}
string name = c.Attributes["name"].Value;
string value = c.InnerText;
if (!string.IsNullOrWhiteSpace(name) && !userAgent.UserAgentList.ContainsKey(name))
{
userAgent.UserAgentList.Add(name, value);
//判断selected属性是否存在
if (c.Attributes["selected"] == null)
{
continue;
}
if (DataConvert.StrToBool(c.Attributes["selected"].Value))
{
userAgent.Selected = new KeyValuePair <string, string>(name, value);
}
}
}
}
return(userAgent);
}
protected override int AddData(Dictionary <string, object> objs, UserInfo sysUser, string viewTitle)
{
string sql = @"select * from AssetsSell where 1<>1 ";
DataTable dt = AppMember.DbHelper.GetDataSet(sql, dbUpdate.cmd).Tables[0];
dt.TableName = "AssetsSell";
DataRow dr = dt.NewRow();
string assetsSellId = IdGenerator.GetMaxId(dt.TableName);
int retApprove = InitFirstApproveTask("AssetsSell", "AssetsSellId", assetsSellId, viewTitle);
foreach (KeyValuePair <string, object> kv in objs)
{
if (kv.Key != "gridData")
{
dr[kv.Key] = kv.Value;
}
}
if (retApprove != 0)
{
dr["approveState"] = "O";
}
dr["AssetsSellId"] = assetsSellId;
Create5Field(dr, sysUser.UserId, viewTitle);
dt.Rows.Add(dr);
dbUpdate.Update(dt);
List <AssetsSell> gridData = JsonHelper.JSONStringToList <AssetsSell>(DataConvert.ToString(objs["gridData"]));
foreach (AssetsSell assetsSell in gridData)
{
AddDetail(assetsSell, assetsSellId, sysUser.UserId, viewTitle);
if (retApprove != 0)
{
UpdateAssetsState(assetsSell.AssetsId, "XI", sysUser.UserId, viewTitle);
}
}
return(1);
}
public JsonResult EntryGridData(string formVar, string formMode, string primaryKey)
{
try
{
int pageIndex = DataConvert.ToInt32(Request.Params["page"]);
int pageRowNum = DataConvert.ToInt32(Request.Params["rows"]);
Dictionary <string, object> paras = SetParas(formVar);
int cnt = Repository.GetGridCount(paras, formMode);
double aa = (double)cnt / pageRowNum;
double pageCnt = Math.Ceiling(aa);
var rows = DataTable2Object.Data(EntryGridDataTable(formVar, formMode, primaryKey), EntryGridLayout().GridLayouts);
var result = new JsonResult();
result.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
result.Data = new { page = pageIndex, records = cnt, total = pageCnt, rows = rows };
return(result);
}
catch (Exception ex)
{
AppLog.WriteLog(AppMember.AppText["SystemUser"], LogType.Error, "AssetsDepreciationController.EntryGridData", "[Message]:" + ex.Message + " [StackTrace]:" + ex.StackTrace);
return(new JsonResult());
}
}
/*
* 后台审核通过,更新头像
*/
protected void Page_Load(object sender, EventArgs e)
{
B_Admin.CheckIsLogged(Request.RawUrl);
B_User buser = new B_User();
B_Content conBll = new B_Content();
string ids = Request["ids"];
int status = DataConvert.CLng(Request["status"]);
switch (status)
{
case (int)ZLEnum.ConStatus.Audited:
if (!string.IsNullOrEmpty(ids))
{
//SafeSC.CheckIDSEx(ids);
//string fields = "B.*,A.Title";
//DataTable dt = DBCenter.JoinQuery(fields, "ZL_CommonModel", "ZL_C_LSSQ", "A.ItemID=B.ID", "A.GeneralID IN (" + ids + ")");
//foreach (DataRow dr in dt.Rows)
//{
// int uid = DataConvert.CLng(dr["yhid"]);
// if (uid < 1) { continue; }
// string faceUrl = ExHelper.Json_GetFirstImage(DataConvert.CStr(dr["tx"]));
// if (string.IsNullOrEmpty(faceUrl)) { faceUrl = "/Images/userface/noface.png"; }
// string name = DataConvert.CStr(dr["Title"]);
// string zsxm = DataConvert.CStr(dr["zsxm"]);
// DBCenter.UpdateSQL("ZL_User", "Salt=@face,HoneyName=@name,[Permissions]=@zsxm", "UserID=" + uid, new List<SqlParameter>()
// { new SqlParameter("face", faceUrl),
// new SqlParameter("name",name),
// new SqlParameter("zsxm",zsxm)
// });
// DBCenter.UpdateSQL("ZL_UserBase","UserFace=@face","UserID="+uid,new List<SqlParameter>() {new SqlParameter("face",faceUrl) });
//}
}
break;
//case (int)ZLEnum.ConStatus.UnAudit:
// break;
}
conBll.UpdateStatus(ids, status);
Response.Write("1"); Response.Flush(); Response.End(); return;
}
public int AddData(Dictionary <string, object> objs, UserInfo sysUser, string viewTitle, string tableName, string pkField, string pkValue, string approveState, bool isInit = false)
{
Dictionary <string, object> paras = new Dictionary <string, object>();
paras.Add("tableName", tableName);
paras.Add("refId", pkValue);
paras.Add("approver", sysUser.UserId);
string sql = @"select isnull(max(seqno),0) seqno from AppApprove where tableName=@tableName and refId=@refId and approver=@approver ";
DataTable dtSeqno = AppMember.DbHelper.GetDataSet(sql, paras, DbUpdate.cmd).Tables[0];
int seqno = DataConvert.ToInt32(dtSeqno.Rows[0]["seqno"]);
sql = @"select * from AppApprove where 1<>1 ";
DataTable dt = AppMember.DbHelper.GetDataSet(sql, DbUpdate.cmd).Tables[0];
dt.TableName = "AppApprove";
DataRow dr = dt.NewRow();
foreach (KeyValuePair <string, object> kv in objs)
{
dr[kv.Key] = kv.Value;
}
if (approveState == "A" && seqno == 0)
{
dr["seqno"] = seqno + 2;
}
else
{
dr["seqno"] = seqno + 1;
}
//dr["approveId"] = IdGenerator.GetMaxId(dt.TableName);
Create5Field(dr, sysUser.UserId, viewTitle);
dt.Rows.Add(dr);
DbUpdate.Update(dt);
if (!isInit)
{
OverrideRefTable(tableName, pkField, pkValue, sysUser, viewTitle, approveState);
}
return(1);
}
public override void SetText()
{
checked
{
if (!string.IsNullOrEmpty(this.Data))
{
string data = this.Data;
int num = 0;
int num2 = DataConvert.HexToInt(data.Substring(num, 2));
num += 2;
for (int i = 0; i < num2; i++)
{
string value = base.OperaRec(data.Substring(num, 4), "A19");
num += 4;
string value2 = base.OperaRec(data.Substring(num, 4), "A19");
num += 4;
this.DataGridView1.Rows[i].Cells[1].Value = value;
this.DataGridView1.Rows[i].Cells[2].Value = value2;
}
}
}
}
protected void SetDataRow(EntryModel model, DataRow dr)
{
dr["assetsClassNo"] = model.AssetsClassNo;
dr["assetsClassName"] = model.AssetsClassName;
dr["parentId"] = DataConvert.ToString(model.ParentId) == "" ? "0" : DataConvert.ToString(model.ParentId);
dr["durableYears"] = DataConvert.ToDBObject(model.DurableYears);
dr["remainRate"] = DataConvert.ToDBObject(model.RemainRate);
dr["unitId"] = model.UnitId;
dr["depreciationType"] = model.DepreciationType;
if (DataConvert.ToString(model.ParentId) == "")
{
dr["assetsClassPath"] = model.AssetsClassId;
}
else
{
Dictionary <string, object> paras = new Dictionary <string, object>();
paras.Add("assetsClassId", model.ParentId);
string sql = @"select assetsClassPath from AssetsClass where assetsClassId=@assetsClassId";
DataTable dtp = AppMember.DbHelper.GetDataSet(sql, paras).Tables[0];
dr["assetsClassPath"] = DataConvert.ToString(dtp.Rows[0]["assetsClassPath"]) + "," + model.AssetsClassId;
}
}
public ActionResult Contact()
{
if (!B_ARoleAuth.AuthCheckEx(ZLEnum.Auth.office, "crm"))
{
return(null);
}
F_CRMS_Contact filter = new F_CRMS_Contact()
{
ClientID = DataConvert.CLng(Request["Cid"], -100),
Name = Request["name"]
};
PageSetting setting = contactBll.SelPage(CPage, PSize, filter);
if (function.isAjax())
{
return(PartialView("Contact_List", setting));
}
else
{
return(View("Contact", setting));
}
}
public ActionResult ClientListDiag()
{
if (!B_ARoleAuth.AuthCheckEx(ZLEnum.Auth.office, "crm"))
{
return(null);
}
int clientId = DataConvert.CLng(Request["Cid"]);
PageSetting setting = clientBll.SelPage(CPage, PSize, new F_CRMS_Client()
{
ctype = Request["ctype"],
ignoreCids = clientId.ToString()
});
if (function.isAjax())
{
return(PartialView("ClientListDiag_List", setting));
}
else
{
return(View(setting));
}
}
protected void saveBtn_Click(object sender, EventArgs e)
{
string st = beginTimeT.Text.Trim();
string et = endTimeT.Text.Trim();
if (string.IsNullOrEmpty(st) || string.IsNullOrEmpty(et))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('时间不能为空!!!');", true);
}
else if (!DataConvert.IsDate(st) || !DataConvert.IsDate(et))
{
//只有时间也能正常判断,格式则为2014-04-10 17:00:00.000
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('日期格式不正确!!!');", true);
}
else if (Convert.ToDateTime(st) >= Convert.ToDateTime(et))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('起始时间不能大于或等于下次结束时间');", true);
}
else
{
//正常处理
bcMod.BCName = bcNameT.Text.Trim();
bcMod.Remind = remindT.Text.Trim();
bcMod.StartTime = Convert.ToDateTime(st);
bcMod.EndTime = Convert.ToDateTime(et);
bcMod.AddTime = DateTime.Now;
bcMod.BackColor = ColorDefault.Text.Trim();
if (!string.IsNullOrEmpty(Request.QueryString["ID"]))
{
bcMod.ID = DataConverter.CLng(Request.QueryString["ID"]);
bcBll.UpdateByID(bcMod);
}
else
{
bcBll.Insert(bcMod);
}
Response.Redirect("BCManage.aspx");
}
}
public List <Categoria> List_Categoria_Paginate(PaginateParams paginateParams)
{
var list = new List <Categoria>();
try
{
SQLServer.OpenConection();
SQLServer.CreateCommand("up_Categoria_Sellst_Paginate", CommandType.StoredProcedure,
SQLServer.CreateParameter("SortDirection", SqlDbType.VarChar, paginateParams.SortDirection),
SQLServer.CreateParameter("SortColumn", SqlDbType.VarChar, paginateParams.SortColumn),
SQLServer.CreateParameter("PageIndex", SqlDbType.Int, paginateParams.PageIndex),
SQLServer.CreateParameter("RowsPerPage", SqlDbType.Int, paginateParams.RowsPerPage),
SQLServer.CreateParameter("Paginate", SqlDbType.Bit, paginateParams.IsPaginate),
SQLServer.CreateParameter("Filters", SqlDbType.Structured, paginateParams.Filters));
using (var dataReader = SQLServer.GetDataReader(CommandBehavior.CloseConnection))
{
while (dataReader.Read())
{
var objCategoria = new Categoria();
paginateParams.TotalRows = DataConvert.ToInt(dataReader["List_TotalRegistros"]);
objCategoria.IDCategoria = DataConvert.ToInt(dataReader["N_IDCategoria"]);
objCategoria.Orden = DataConvert.ToInt(dataReader["N_Orden"]);
objCategoria.Descripcion = DataConvert.ToString(dataReader["S_Descripcion"]);
objCategoria.Color = DataConvert.ToString(dataReader["S_Color"]);
objCategoria.Estado = DataConvert.ToString(dataReader["S_Estado"]).Equals("ACT") ? "Activo" : "Inactivo";
list.Add(objCategoria);
}
}
SQLServer.CloseConection();
}
catch (Exception ex)
{
Log _log = new Log {
IDCategoria = 2, UsuarioCreacion = "", Mensaje = "Origen:REPOSITORY - Método:List_Categoria_Paginate(Repository Categoria) - Error:" + ex.GetBaseException().ToString()
};
_LogRepository.Insert(_log);
}
return(list);
}
protected override int Add(EntryViewModel model, UserInfo sysUser, string viewTitle)
{
string sql = @"select * from AssetsLease where 1<>1 ";
DataTable dt = AppMember.DbHelper.GetDataSet(sql, DbUpdate.cmd).Tables[0];
dt.TableName = "AssetsLease";
DataRow dr = dt.NewRow();
string assetsLeaseId = IdGenerator.GetMaxId(dt.TableName);
int retApprove = InitFirstApproveTask("AssetsLease", "AssetsLeaseId", assetsLeaseId, viewTitle, "", sysUser.UserId);
EntryModel myModel = model as EntryModel;
dr["assetsLeaseNo"] = myModel.AssetsLeaseNo;
dr["assetsLeaseName"] = myModel.AssetsLeaseName;
dr["leaseDate"] = DataConvert.ToDBObject(myModel.LeaseDate);
string updateType = "Add";
if (retApprove != 0)
{
dr["approveState"] = "O";
updateType = "ApproveAdd";
}
dr["AssetsLeaseId"] = assetsLeaseId;
dr["setBooksId"] = sysUser.MySetBooks.SetBooksId;
dt.Rows.Add(dr);
Create5Field(dt, sysUser.UserId, viewTitle);
DbUpdate.Update(dt);
List <AssetsLease> gridData = JsonHelper.JSONStringToList <AssetsLease>(DataConvert.ToString(myModel.EntryGridString));
foreach (AssetsLease assetsLease in gridData)
{
AddDetail(assetsLease, assetsLeaseId, sysUser, viewTitle, updateType);
if (retApprove != 0)
{
UpdateAssetsState(assetsLease.AssetsId, "LI", sysUser.UserId, viewTitle);
}
}
return(1);
}
//动态绑定权限列表
private void CreatePermisssionList()
{
Johnny.CMS.BLL.Access.PermissionCategory category = new Johnny.CMS.BLL.Access.PermissionCategory();
IList <Johnny.CMS.OM.Access.PermissionCategory> categoryModel = category.GetList();
string hdnSeletedClientID = "";
string hdnRightClientID = "";
foreach (Johnny.CMS.OM.Access.PermissionCategory item in categoryModel)
{
permissioncontrol permissionCtrl = (permissioncontrol)LoadControl("..\\usercontrol\\permissioncontrol.ascx");
permissionCtrl.RoleId = DataConvert.GetInt32(ddlRoles.SelectedValue);
permissionCtrl.PermissionCategoryId = item.PermissionCategoryId;
permissionCtrl.PermissionCategoryName = item.PermissionCategoryName;
PlaceHolder1.Controls.Add(permissionCtrl);
HtmlInputHidden hdnValue = (HtmlInputHidden)permissionCtrl.FindControl("hdnSelected");
HtmlSelect hdnRightList = (HtmlSelect)permissionCtrl.FindControl("lstRight");
hdnSeletedClientID = hdnSeletedClientID + hdnValue.ClientID + ",";
hdnRightClientID = hdnRightClientID + hdnRightList.ClientID + ",";
}
btnSave.Attributes.Add("onclick", "return Save('" + ddlRoles.ClientID + "','" + hdnSeletedClientID + "','" + hdnAllSelected.ClientID + "');");
btnReset.Attributes.Add("onclick", "listClear('" + hdnRightClientID + "','" + hdnSeletedClientID + "','" + hdnAllSelected.ClientID + "');return false;");
}
protected int AddDetail(AssetsLease AssetsLease, string AssetsLeaseId, UserInfo sysUser, string viewTitle, string updateType)
{
string sql = @"select * from AssetsLeaseDetail where 1<>1 ";
DataTable dt = AppMember.DbHelper.GetDataSet(sql).Tables[0];
dt.TableName = "AssetsLeaseDetail";
DataRow dr = dt.NewRow();
dr["AssetsLeaseId"] = AssetsLeaseId;
dr["assetsId"] = AssetsLease.AssetsId;
dr["remark"] = AssetsLease.Remark;
dr["leaseCompany"] = AssetsLease.LeaseCompany;
dr["leaseAmount"] = AssetsLease.LeaseAmount;
dr["setBooksId"] = sysUser.MySetBooks.SetBooksId;
dt.Rows.Add(dr);
if (DataConvert.ToString(AssetsLease.CreateId) != "")
{
if (updateType == "Reapply")
{
dr["approveState"] = "O";
}
else
{
dr["approveState"] = AssetsLease.ApproveState;
}
dr["createId"] = AssetsLease.CreateId;
dr["createTime"] = AssetsLease.CreateTime;
Update5Field(dt, sysUser.UserId, viewTitle);
}
else
{
if (updateType == "ApproveAdd")
{
dr["approveState"] = "O";
}
Create5Field(dt, sysUser.UserId, viewTitle);
}
return(DbUpdate.Update(dt));
}
public ActionResult CheckPeriod(string fiscalYearId, string fiscalPeriodId)
{
try
{
DataRow dr = Repository.GetModel();
if (dr == null || (DataConvert.ToString(dr["fiscalYearIdNext"]) == fiscalYearId &&
DataConvert.ToString(dr["fiscalPeriodIdNext"]) == fiscalPeriodId))
{
return(Content("1", "text/html"));
}
else
{
string msg = AppMember.AppText["DepreciationPeriod"] + DataConvert.ToString(dr["fiscalYearIdNextName"]) + "-" + DataConvert.ToString(dr["fiscalPeriodIdNextName"]);
return(Content(msg, "text/html"));
}
}
catch (Exception ex)
{
AppLog.WriteLog(AppMember.AppText["SystemUser"], LogType.Error, "AssetsDepreciationController.CheckPeriod", "[Message]:" + ex.Message + " [StackTrace]:" + ex.StackTrace);
return(Content("[Message]:" + ex.Message + " [StackTrace]:" + ex.StackTrace, "text/html"));
}
}
/// <summary>
/// 发送验证码短信
/// </summary>
public static CommonReturn SendVCode(string mobile, string vcode, string tlp)
{
SMS_Packet packet = new SMS_Packet();
packet.message = tlp;
switch (SMSConfig.Instance.DefaultSMS)
{
case "qcloud":
packet.param.Add("0", vcode);
packet.tlpId = DataConvert.CLng(tlp);
break;
default:
if (string.IsNullOrEmpty(packet.message))
{
return(CommonReturn.Failed("未指定短信模板内容"));
}
break;
}
packet.message = packet.message.Replace("{vcode}", vcode);
return(Send(new string[] { mobile }, packet));
}
public ActionResult StockList()
{
M_Store_Info storeMod = storeBll.SelModelByUser(mu.UserID);
F_Stock filter = new F_Stock()
{
NodeID = DataConvert.CLng(Request["NodeID"]),
ProID = DataConvert.CLng(Request["ProID"]),
StockType = DataConvert.CLng(Request["StockType"]),
StoreID = storeMod.ID,
ProName = Request["ProName"],
AddUser = Request["AddUser"],
SDate = Request["SDate"],
EDate = Request["EDate"]
};
PageSetting setting = stockBll.SelPage(CPage, PSize, filter);
if (Request.IsAjaxRequest())
{
return(PartialView("StockList_List", setting));
}
return(View(setting));
}
protected void Page_Init(object sender, EventArgs e)
{
WxAPI.AutoSync(Request.Url.AbsoluteUri);
int sid = DataConvert.CLng(Request.QueryString["ID"]);
if (sid > 1)
{
Response.Cookies["sid"].Value = sid.ToString();
}
else if (Request.Cookies["sid"] != null)//看Cookie中是否有信息
{
sid = DataConvert.CLng(Request.Cookies["sid"].Value);
}
if (sid < 1)
{
function.WriteErrMsg("未指定店铺ID"); return;
}
if (!DBCenter.IsExist("ZL_CommonModel", "GeneralID=" + sid + " AND ModelID=24"))
{
function.WriteErrMsg("指定店铺的信息不存在");
}
}
/// <summary>
/// 返回符合查询条件的试卷
/// </summary>
/// <returns>符合查询条件的试卷</returns>
public IList <ExamResult> GetExamResults(int examId, string organizationName, /*int examId,*/ string examineeName,
decimal scoreLower, decimal scoreUpper, int statusId, /*int judgeId,*/ int startRowIndex, int pageSize, string orderBy)
{
IList <ExamResult> examResults = new List <ExamResult>();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_EXAM_RESULT_F";//USP_EXAM_RESULT_S
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_exam_id", DbType.Int32, examId);
db.AddInParameter(dbCommand, "p_org_name", DbType.String, organizationName);
//db.AddInParameter(dbCommand, "p_exam_id", DbType.Int32, examId);
db.AddInParameter(dbCommand, "p_examinee_name", DbType.String, examineeName);
db.AddInParameter(dbCommand, "p_status_id", DbType.Int32, statusId);
//db.AddInParameter(dbCommand, "p_judge_id", DbType.Int32, judgeId);
db.AddInParameter(dbCommand, "p_score_lower", DbType.Decimal, scoreLower);
db.AddInParameter(dbCommand, "p_score_upper", DbType.Decimal, scoreUpper);
db.AddInParameter(dbCommand, "p_start_row_index", DbType.Int32, startRowIndex);
db.AddInParameter(dbCommand, "p_page_size", DbType.Int32, pageSize);
db.AddInParameter(dbCommand, "p_order_by", DbType.String, GetMappingOrderBy(orderBy));
//db.AddOutParameter(dbCommand, "p_count", DbType.Int32, 4);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
ExamResult er = null;
while (dataReader.Read())
{
er = CreateModelObject(dataReader);
er.WorkNo = DataConvert.ToString(dataReader[GetMappingFieldName("WorkNo")]);
er.PostName = DataConvert.ToString(dataReader[GetMappingFieldName("PostName")]);
examResults.Add(er);
}
}
//_recordCount = (int)db.GetParameterValue(dbCommand, "p_count");
return(examResults);
}
public IActionResult Promo()
{
string PStr = GetParam("p");
string PUName = GetParam("pu");
int PUserID = DataConvert.CLng(EncryptHelper.DesDecrypt(PStr));
if (PUserID < 1 && string.IsNullOrEmpty(PUName))
{
return(WriteErr("无用户信息"));
}
if (PUserID > 0)
{
mu = buser.SelReturnModel(PUserID);
}
else if (!string.IsNullOrEmpty(PUName))
{
mu = buser.GetUserByName(PUName);
}
//if (mu.UserID < 1) { function.WriteErrMsg("推广用户不存在");return; }
//if (mu.UserID > 1) { Response.Cookies["UserState2"]["ParentUserID"] = mu.UserID.ToString(); }
return(Redirect("/User/Register?ParentUserID=" + mu.UserID));
}
protected void btnAdd_Click(object sender, System.EventArgs e)
{
//check category name
if (!CheckInputEmptyAndLength(txtPermissionName, "E01301", "E01302", false))
{
return;
}
Johnny.CMS.BLL.Access.Permission bll = new Johnny.CMS.BLL.Access.Permission();
Johnny.CMS.OM.Access.Permission model = new Johnny.CMS.OM.Access.Permission();
if (Request.QueryString["action"] == "modify")
{
//update
model.PermissionId = Convert.ToInt32(Request.QueryString["id"]);
model.PermissionName = txtPermissionName.Text;
model.PermissionCategoryId = DataConvert.GetInt32(ddlCategory.SelectedValue);
bll.Update(model);
SetMessage(GetMessage("C00003"));
}
else
{
//insert
model.PermissionName = txtPermissionName.Text;
model.PermissionCategoryId = DataConvert.GetInt32(ddlCategory.SelectedValue);
if (bll.Add(model) > 0)
{
SetMessage(GetMessage("C00001"));
ddlCategory.SelectedIndex = 0;
txtPermissionName.Text = "";
}
else
{
SetMessage(GetMessage("C00002"));
}
}
}
public Usuario Insert(Usuario item)
{
var objResult = new Usuario();
try
{
var oDatabase = DatabaseFactory.CreateDatabase();
var oDbCommand = oDatabase.GetStoredProcCommand("up_Usuario_Ins");
oDatabase.AddInParameter(oDbCommand, "@ApellidoMaterno", DbType.String, item.ApellidoMaterno);
oDatabase.AddInParameter(oDbCommand, "@ApellidoPaterno", DbType.String, item.ApellidoPaterno);
oDatabase.AddInParameter(oDbCommand, "@CorreoElectronico", DbType.String, item.CorreoElectronico);
oDatabase.AddInParameter(oDbCommand, "@DistritoId", DbType.Int32, item.DistritoId);
oDatabase.AddInParameter(oDbCommand, "@DNI", DbType.String, item.DNI);
oDatabase.AddInParameter(oDbCommand, "@EspecialidadId", DbType.Int32, item.EspecialidadId);
oDatabase.AddInParameter(oDbCommand, "@EsTrabajador", DbType.Int32, item.EsTrabajador?1:0);
oDatabase.AddInParameter(oDbCommand, "@strFechaNacimiento", DbType.String, item.strFechaNacimiento);
oDatabase.AddInParameter(oDbCommand, "@Nombres", DbType.String, item.Nombres);
oDatabase.AddInParameter(oDbCommand, "@NumeroContacto1", DbType.String, item.NumeroContacto1);
oDatabase.AddInParameter(oDbCommand, "@NumeroContacto2", DbType.String, item.NumeroContacto2);
oDatabase.AddInParameter(oDbCommand, "@TieneEstudios", DbType.Int32, item.TieneEstudios?1:0);
oDatabase.AddInParameter(oDbCommand, "@Password", DbType.String, item.Password);
oDatabase.AddInParameter(oDbCommand, "@Estado", DbType.String, item.Estado);
oDatabase.AddInParameter(oDbCommand, "@DeviceToken", DbType.String, item.DeviceToken);
oDatabase.AddInParameter(oDbCommand, "@Origen", DbType.String, item.Origen);
oDatabase.AddInParameter(oDbCommand, "@UsuarioIDExterno", DbType.String, item.UsuarioIDExterno);
objResult.UsuarioId = DataConvert.ToInt32(oDatabase.ExecuteScalar(oDbCommand));
}
catch (Exception ex)
{
Log _log = new Log
{
IDCategoria = 2,
UsuarioCreacion = "",
Mensaje = "Origen:REPOSITORY - Método:Insert(Repository Usuario) - Error:" + ex.GetBaseException().ToString()
};
_LogRepository.Insert(_log);
}
return(objResult);
}
/// <summary>
/// 根据查询条件获取对象集合
/// </summary>
/// <param name="top">查询数量(0:查询所有)</param>
/// <param name="conditions">查询（排序）项集合</param>
/// <returns>查询结果集合</returns>
public override List <T> FindByCondition(int top, List <Item> items)
{
//构造查询条件
List <DbParameter> pars = new List <DbParameter>();
//生成查询语句
string conSql = getConditionSQL(items, pars);//sql条件部分
string sql;
if (top > 0)
{
conSql += " ORDER BY " + primaryKey + " LIMIT 0," + top;
}
sql = String.Format(selectSQL, "*", tableName, conSql);
List <T> list = new List <T>();
list = DataConvert <T> .ToEntities(DBHelper.Query(sql, pars));
return(list);
}
public Usuario UsuarioPorCorreoRS(string CorreoElectronico, string Key)
{
Usuario objUsuario = null;
var oDatabase = DatabaseFactory.CreateDatabase();
var oDbCommand = oDatabase.GetStoredProcCommand("up_Usuario_Sel_Usuario_Por_CorreoRS");
oDatabase.AddInParameter(oDbCommand, "@CorreoElectronico", DbType.String, CorreoElectronico);
oDatabase.AddInParameter(oDbCommand, "@Key", DbType.String, Key);
using (var oReader = oDatabase.ExecuteReader(oDbCommand))
{
while (oReader.Read())
{
objUsuario = new Usuario
{
UsuarioId = DataConvert.ToInt32(oReader["N_UsuarioId"]),
ApellidoPaterno = DataConvert.ToString(oReader["S_ApellidoPaterno"]),
ApellidoMaterno = DataConvert.ToString(oReader["S_ApellidoMaterno"]),
CorreoElectronico = DataConvert.ToString(oReader["S_CorreoElectronico"]),
DistritoId = DataConvert.ToInt32(oReader["N_DistritoId"]),
CategoriaId = DataConvert.ToInt32(oReader["N_CategoriaId"]),
ProvinciaId = DataConvert.ToInt32(oReader["N_ProvinciaId"]),
DepartamentoId = DataConvert.ToInt32(oReader["N_DepartamentoId"]),
DNI = DataConvert.ToString(oReader["S_DNI"]),
EspecialidadId = DataConvert.ToInt32(oReader["N_EspecialidadId"]),
EsTrabajador = DataConvert.ToBool(oReader["N_EsTrabajador"]),
FechaNacimiento = DataConvert.ToDateTime(oReader["D_FechaNacimiento"]),
Nombres = DataConvert.ToString(oReader["S_Nombres"]),
NumeroContacto1 = DataConvert.ToString(oReader["S_NumeroContacto1"]),
NumeroContacto2 = DataConvert.ToString(oReader["S_NumeroContacto2"]),
TieneEstudios = DataConvert.ToBool(oReader["N_TieneEstudios"]),
DeviceToken = DataConvert.ToString(oReader["S_DeviceToken"]),
Estado = DataConvert.ToString(oReader["S_Usuario_Estado"])
};
}
oReader.Close();
}
return(objUsuario);
}
private void OnTaskStopClick(object sender, EventArgs e)
{
try
{
TaskNode tn = this.SelectedNode as TaskNode;
if (tn != null)
{
//icon
tn.ImageIndex = DataConvert.GetInt32(IconType.Task);
tn.SelectedImageIndex = DataConvert.GetInt32(IconType.Task);
TaskEventArgs te = new TaskEventArgs();
te.Task = tn.Task;
OnStopTask(te);
_executingTaskIdList.Remove(tn.Task.TaskId);
}
}
catch (Exception ex)
{
ErrorHandler.ShowMessageBox(CGConstants.MODULE_TASKTREE, ex);
}
}
/// <summary>
/// 测试数据输出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void TestDataOutputbutton_Click(object sender, RoutedEventArgs e)
{
string sFileStyle = "SIG File(.signaltester) | *.signaltester";
string UIKey = "TestdataOutPutFilePathteBox";
string UIKey1 = "OutPutDatasteBox";
string UIKey3 = "L1raButton";
string UIKey4 = "L2raButton";
string sFilePath = UIdictionary[UIKey].MyString;
try
{
bool bOpenEnable = Outputfile(ref sFilePath, sFileStyle);
if (bOpenEnable == true)
{
BaseFactory factory = new BaseFactory();
factory.BaseParameter = CreateConvertParameter();
TestData TestData = (TestData)factory.CreatDataClass("TestData");
List <List <string> > TestDataList = new List <List <string> >();
if (UIdictionary[UIKey3].Mybool == true)
{
CreateDataMath <string, List <ConveyorRow> > dataMath = TestData.CreateL1Signal;
TestDataList = TestData.CreateList(dataMath);
}
if (UIdictionary[UIKey4].Mybool == true)
{
CreateDataMath <string, List <ConveyorRow> > dataMath = TestData.CreateL2Signal;
TestDataList = TestData.CreateList(dataMath);
}
UIdictionary[UIKey].MyString = sFilePath;
UIdictionary[UIKey1].MyString = DataConvert.ToString(TestDataList);
System.IO.File.WriteAllText(@sFilePath, UIdictionary[UIKey1].MyString, Encoding.UTF8);
}
}
catch (Exception ex)
{
MessageBox.Show("Build Test data Error： " + ex.Message);
}
GC.Collect();
}
