public static A2ZSYSIDSDTO GetUserInformation(int userId, string dbName)
{
DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZSYSIDS WHERE IdsNo = " + userId, dbName);
var p = new A2ZSYSIDSDTO();
if (dt.Rows.Count > 0)
{
p.IdsNo = Converter.GetInteger(dt.Rows[0]["IdsNo"]);
p.IdsPass = Converter.GetString(dt.Rows[0]["IdsPass"]);
p.IdsLevel = Converter.GetSmallInteger(dt.Rows[0]["IdsLevel"]);
p.IdsLogInFlag = Converter.GetSmallInteger(dt.Rows[0]["IdsLogInFlag"]);
p.IdsLockFlag = Converter.GetSmallInteger(dt.Rows[0]["IdsLockFlag"]);
p.IdsName = Converter.GetString(dt.Rows[0]["IdsName"]);
p.IdsFlag = Converter.GetSmallInteger(dt.Rows[0]["IdsFlag"]);
p.IdsType = Converter.GetSmallInteger(dt.Rows[0]["IdsType"]);
p.IdsStatus = Converter.GetSmallInteger(dt.Rows[0]["IdsStatus"]);
p.GLCashCode = Converter.GetInteger(dt.Rows[0]["GLCashCode"]);
p.EmpCode = Converter.GetInteger(dt.Rows[0]["EmpCode"]);
p.UserBranchNo = Converter.GetInteger(dt.Rows[0]["UserBranchNo"]);
p.SODflag = Converter.GetBoolean(dt.Rows[0]["IdsSODFlag"]);
p.VPrintflag = Converter.GetBoolean(dt.Rows[0]["IdsVPrintFlag"]);
p.AutoVchflag = Converter.GetBoolean(dt.Rows[0]["IdsAutoVchFlag"]);
p.IdsMobile = Converter.GetBoolean(dt.Rows[0]["IdsMobile"]);
return(p);
}
p.IdsNo = 0;
return(p);
}
public static int InsertNewIdInformation(A2ZSYSIDSDTO objIds)
{
int rowwEffect = 0;
string strQuery = "INSERT INTO A2ZSYSIDS(IdsNo,IdsName,IdsLevel,IdsFlag,EmpCode,UserId,IdsPass,IdsLogInFlag,IdsLockFlag,IdsType,IdsStatus,GLCashCode,IdsSODFlag,IdsVPrintFlag,IdsCWarehouseFlag)" +
"VALUES ('" + objIds.IdsNo + "','" + objIds.IdsName + "','" + objIds.IdsLevel + "','" + objIds.IdsFlag + "','" +
objIds.EmpCode + "','" + objIds.UserId + "','XXXXXXXX',0,0,0,0,'" + objIds.GLCashCode + "','" + objIds.SODflag + "','" + objIds.VPrintflag + "','" + objIds.IdsCWarehouseflag + "')";
//rowwEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZOBTMCUS"));
rowwEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZCSMCUS"));
rowwEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZHKMCUS"));
rowwEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZHRMCUS"));
rowwEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZGLMCUS"));
rowwEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZBTMCUS"));
rowwEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZSTMCUS"));
return(rowwEffect);
}
public static int UpdateNewPassword(A2ZSYSIDSDTO objIds)
{
int rowwEffect = 0;
string strQuery = "UPDATE A2ZSYSIDS SET IdsPass = '******' WHERE IdsNo = '" + objIds.IdsNo + "'";
rowwEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZHKOMS"));
//rowwEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZBTCUBS"));
rowwEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZACOMS"));
//rowwEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZHRCUBS"));
//rowwEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZGLCUBS"));
//rowwEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZOBTMCUS"));
return(rowwEffect);
}
public static int Update(A2ZSYSIDSDTO objIds)
{
int rowwEffect = 0;
string strQuery = "UPDATE A2ZSYSIDS SET IdsLevel='" + objIds.IdsLevel + "',IdsName='" + objIds.IdsName + "',EmpCode='" + objIds.EmpCode + "',IdsFlag='" + objIds.IdsFlag + "', GLCashCode = '" + objIds.GLCashCode + "', IdsSODFlag = '" + objIds.SODflag + "', IdsVPrintFlag = '" + objIds.VPrintflag + "',IdsAutoVchFlag = '" + objIds.AutoVchflag + "',IdsMobile = '" + objIds.IdsMobile + "' WHERE IdsNo = '" + objIds.IdsNo + "'";
rowwEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZACWMS"));
rowwEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZHKWMS"));
return(rowwEffect);
}
public static int InsertNewIdInformation(A2ZSYSIDSDTO objIds)
{
int rowwEffect = 0;
string strQuery = "INSERT INTO A2ZSYSIDS(IdsNo,IdsName,IdsLevel,IdsFlag,EmpCode,UserId,IdsPass,IdsLogInFlag,IdsLockFlag,IdsType,IdsStatus,GLCashCode,UserBranchNo,IdsSODFlag,IdsVPrintFlag,IdsAutoVchFlag,IdsMobile)" +
"VALUES ('" + objIds.IdsNo + "','" + objIds.IdsName + "','" + objIds.IdsLevel + "','" + objIds.IdsFlag + "','" +
objIds.EmpCode + "','" + objIds.UserId + "','XXXXXXXX',0,0,0,0,'" + objIds.GLCashCode + "','" + objIds.UserBranchNo + "','" + objIds.SODflag + "','" + objIds.VPrintflag + "','" + objIds.AutoVchflag + "','" + objIds.IdsMobile + "')";
rowwEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZACWMS"));
rowwEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZHKWMS"));
return(rowwEffect);
}
public static int Update(A2ZSYSIDSDTO objIds)
{
int rowwEffect = 0;
string strQuery = "UPDATE A2ZSYSIDS SET IdsLevel='" + objIds.IdsLevel + "',IdsName='" + objIds.IdsName + "',EmpCode='" + objIds.EmpCode + "',IdsFlag='" + objIds.IdsFlag + "', GLCashCode = '" + objIds.GLCashCode + "', IdsSODFlag = '" + objIds.SODflag + "', IdsVPrintFlag = '" + objIds.VPrintflag + "',IdsCWarehouseFlag = '" + objIds.IdsCWarehouseflag + "' WHERE IdsNo = '" + objIds.IdsNo + "'";
//rowwEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZOBTMCUS"));
rowwEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZHKMCUS"));
rowwEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZHRMCUS"));
rowwEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZGLMCUS"));
rowwEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZBTMCUS"));
rowwEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZCSMCUS"));
rowwEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZSTMCUS"));
return(rowwEffect);
}