//寫入db MIP_HAPPY_TARGET
private int insert_MIP_MSG_TARGET(System.Data.SqlClient.SqlCommand cmd
, string isChkALL
, int HAPPY_ID
, string isRCorRM
, string IDsandDEP)
{
int nRet = 0;
string isIc = "";
string isRm = "";
int length = 0;
isIc = isRCorRM.Split('.')[0];
isRm = isRCorRM.Split('.')[1];
length = isRCorRM.Split('.').Length;
// 宣告DAO
MIP_HAPPY_TARGET mip_happy_target_impl = new MIP_HAPPY_TARGET();
//新增角色:IC 或 RM
cmd.Parameters.Clear();
string strSQL = "INSERT INTO MIP_HAPPY_TARGET(HAPPY_TARGET_ID, HAPPY_ID, DEPT_ID,DTYPE)VALUES (@HAPPY_TARGET_ID, @HAPPY_ID,@DEPT_ID,@DTYPE)";
cmd.CommandText = strSQL;
int HAPPY_TARGET_ID = 0;
for (int c = 0; c < length; c++)
{
if (isIc != "")
{
cmd.Parameters.Clear();
HAPPY_TARGET_ID = MIPLibrary.MIPUtil.getFILE_INDEX_SEQ(cmd.Connection, cmd.Transaction);
mip_happy_target_impl.HAPPY_TARGET_ID = HAPPY_TARGET_ID; //tagertID編號
mip_happy_target_impl.HAPPY_ID = HAPPY_ID; //MIP_HAPPY 編號
mip_happy_target_impl.DEPT_ID = isIc; //資料為 IC 或 RM
mip_happy_target_impl.DTYPE = 0; //0:角色;1:單位
nRet = mip_happy_target_impl.Insert(cmd);
isIc = "";
if (nRet == -1)
{
cmd.Transaction.Rollback();
return(nRet);
}
}
if (isRm != "")
{
cmd.Parameters.Clear();
HAPPY_TARGET_ID = MIPLibrary.MIPUtil.getFILE_INDEX_SEQ(cmd.Connection, cmd.Transaction);
mip_happy_target_impl.HAPPY_TARGET_ID = HAPPY_TARGET_ID; //tagertID編號
mip_happy_target_impl.HAPPY_ID = HAPPY_ID; //MIP_HAPPY 編號
mip_happy_target_impl.DEPT_ID = isRm; //資料為 IC 或 RM
mip_happy_target_impl.DTYPE = 0; //0:角色;1:單位
mip_happy_target_impl.Insert(cmd);
isRm = "";
if (nRet == -1)
{
cmd.Transaction.Rollback();
return(nRet);
}
}
}
//新增單位
if (isChkALL == "1")
{
string strSQL2 = "INSERT INTO MIP_HAPPY_TARGET(HAPPY_TARGET_ID, HAPPY_ID, PCAGROUP_ID, DEPT_ID,DTYPE)VALUES (@HAPPY_TARGET_ID, @HAPPY_ID, @PCAGROUP_ID, @DEPT_ID,@DTYPE)";
string[] IDsandDEPs = IDsandDEP.Split(new String[] { "^^" }, StringSplitOptions.RemoveEmptyEntries);
foreach (string IdDepID in IDsandDEPs)
{
cmd.Parameters.Clear();
HAPPY_TARGET_ID = MIPLibrary.MIPUtil.getFILE_INDEX_SEQ(cmd);
cmd.CommandText = strSQL2;
string id = IdDepID.Split(new String[] { "##" }, StringSplitOptions.RemoveEmptyEntries)[0];
string depID = IdDepID.Split(new String[] { "##" }, StringSplitOptions.RemoveEmptyEntries)[1];
mip_happy_target_impl.HAPPY_TARGET_ID = HAPPY_TARGET_ID; //tagertID編號
mip_happy_target_impl.HAPPY_ID = HAPPY_ID; //mipmsg 編號
mip_happy_target_impl.PCAGROUP_ID = id; //群組id
mip_happy_target_impl.DEPT_ID = depID; //單位id
mip_happy_target_impl.DTYPE = 1; //0:角色;1:單位
nRet = mip_happy_target_impl.Insert_all(cmd);
if (nRet == -1)
{
cmd.Transaction.Rollback();
return(nRet);
}
}
return(nRet);
}
else if (isChkALL == "0")
{
//建立新的 command 承接 參數 避免 弄錯
SqlCommand cmd1 = new SqlCommand();
cmd1 = cmd;
//取得 對像名單
List <Dictionary <string, string> > targetList = getPCAGROUP_IDandDEPT_ID(cmd1);
cmd.Parameters.Clear();
string strSQL3 = " INSERT INTO MIP_HAPPY_TARGET (HAPPY_TARGET_ID, HAPPY_ID,PCAGROUP_ID, DEPT_ID, DTYPE)values(@HAPPY_TARGET_ID, @HAPPY_ID, @PCAGROUP_ID, @DEPT_ID, @DTYPE) ";
cmd.CommandText = strSQL3;
foreach (Dictionary <string, string> get in targetList)
{
cmd.Parameters.Clear();
HAPPY_TARGET_ID = MIPLibrary.MIPUtil.getFILE_INDEX_SEQ(cmd.Connection, cmd.Transaction);
mip_happy_target_impl.HAPPY_TARGET_ID = HAPPY_TARGET_ID; //tagertID編號
mip_happy_target_impl.HAPPY_ID = HAPPY_ID; //mipmsg 編號
mip_happy_target_impl.PCAGROUP_ID = get["PCAGROUP_ID"]; //群組id
mip_happy_target_impl.DEPT_ID = get["DEPT_ID"]; //單位id
mip_happy_target_impl.DTYPE = 1; //0:角色;1:單位
nRet = mip_happy_target_impl.Insert_all(cmd);
if (nRet == -1)
{
cmd.Transaction.Rollback();
return(nRet);
}
}
}
return(nRet);
}
//寫入db MIP_HAPPY_TARGET
private int insert_MIP_MSG_TARGET(System.Data.SqlClient.SqlCommand cmd
, string isChkALL
, string HAPPY_ID
, string isRCorRM
, string IDsandDEP)
{
int nRet = 0;
string isIc = "";
string isRm = "";
int length = 0;
length = isRCorRM.Split(',').Length;
if (length == 1)
{
isIc = isRCorRM.Split(',')[0].Equals("IC") ? "IC":"";
isRm = isRCorRM.Split(',')[0].Equals("RM") ? "RM" : "";
}
else if (length == 2)
{
isIc = isRCorRM.Split(',')[0].Equals("IC") ? "IC" : "";
isRm = isRCorRM.Split(',')[1].Equals("RM") ? "RM" : "";
}
cmd.Parameters.Clear();
string delSql = " delete from MIP_HAPPY_TARGET where HAPPY_ID = @HAPPY_ID ";
cmd.CommandText = delSql;
cmd.Parameters.Add(new SqlParameter("@HAPPY_ID", HAPPY_ID));//tagertID編號
nRet = cmd.ExecuteNonQuery();
if (nRet == -1)
{
cmd.Transaction.Rollback();
return(nRet);
}
//新增角色:IC 或 RM
cmd.Parameters.Clear();
string strSQL = "INSERT INTO MIP_HAPPY_TARGET(HAPPY_TARGET_ID, HAPPY_ID, DEPT_ID,DTYPE)VALUES (@HAPPY_TARGET_ID, @HAPPY_ID,@DEPT_ID,@DTYPE)";
cmd.CommandText = strSQL;
int HAPPY_TARGET_ID = 0;
for (int c = 0; c < length; c++)
{
if (isIc != "")
{
cmd.Parameters.Clear();
HAPPY_TARGET_ID = MIPLibrary.MIPUtil.getFILE_INDEX_SEQ(cmd.Connection, cmd.Transaction);
cmd.Parameters.Add(new SqlParameter("@HAPPY_TARGET_ID", HAPPY_TARGET_ID)); //tagertID編號
cmd.Parameters.Add(new SqlParameter("@HAPPY_ID", HAPPY_ID)); //MIP_HAPPY 編號
cmd.Parameters.Add(new SqlParameter("@DEPT_ID", isIc)); //資料為 RC 或 RM
cmd.Parameters.Add(new SqlParameter("@DTYPE", "0")); //0:角色;1:單位
nRet = cmd.ExecuteNonQuery();
isIc = "";
if (nRet == -1)
{
cmd.Transaction.Rollback();
return(nRet);
}
}
if (isRm != "")
{
cmd.Parameters.Clear();
HAPPY_TARGET_ID = MIPLibrary.MIPUtil.getFILE_INDEX_SEQ(cmd.Connection, cmd.Transaction);
cmd.Parameters.Add(new SqlParameter("@HAPPY_TARGET_ID", HAPPY_TARGET_ID)); //tagertID編號
cmd.Parameters.Add(new SqlParameter("@HAPPY_ID", HAPPY_ID)); //MIP_HAPPY 編號
//cmd.Parameters.Add(new SqlParameter("@PCAGROUP_ID", DBNull.Value));//群組id
cmd.Parameters.Add(new SqlParameter("@DEPT_ID", isRm)); //資料為 RC 或 RM
cmd.Parameters.Add(new SqlParameter("@DTYPE", "0")); //0:角色;1:單位
nRet = cmd.ExecuteNonQuery();
isRm = "";
if (nRet == -1)
{
cmd.Transaction.Rollback();
return(nRet);
}
}
}
//新增單位
if (isChkALL == "1")
{
string strSQL2 = "INSERT INTO MIP_HAPPY_TARGET(HAPPY_TARGET_ID, HAPPY_ID, PCAGROUP_ID, DEPT_ID,DTYPE)VALUES (@HAPPY_TARGET_ID, @HAPPY_ID, @PCAGROUP_ID, @DEPT_ID,@DTYPE)";
string[] IDsandDEPs = IDsandDEP.Split(new String[] { "^^" }, StringSplitOptions.RemoveEmptyEntries);
foreach (string IdDepID in IDsandDEPs)
{
cmd.Parameters.Clear();
HAPPY_TARGET_ID = MIPLibrary.MIPUtil.getFILE_INDEX_SEQ(cmd);
cmd.CommandText = strSQL2;
string id = IdDepID.Split(new String[] { "##" }, StringSplitOptions.RemoveEmptyEntries)[0];
string depID = IdDepID.Split(new String[] { "##" }, StringSplitOptions.RemoveEmptyEntries)[1];
cmd.Parameters.Add(new SqlParameter("@HAPPY_TARGET_ID", HAPPY_TARGET_ID)); //tagertID編號
cmd.Parameters.Add(new SqlParameter("@HAPPY_ID", HAPPY_ID)); //mipmsg 編號
cmd.Parameters.Add(new SqlParameter("@PCAGROUP_ID", id)); //群組id
cmd.Parameters.Add(new SqlParameter("@DEPT_ID", depID)); //單位id
cmd.Parameters.Add(new SqlParameter("@DTYPE", "1"));
nRet = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
if (nRet == -1)
{
cmd.Transaction.Rollback();
return(nRet);
}
}
return(nRet);
}
else if (isChkALL == "0")
{
//建立新的 command 承接 參數 避免 弄錯
SqlCommand cmd1 = new SqlCommand();
cmd1 = cmd;
//取得 對像名單
List <Dictionary <string, string> > targetList = getPCAGROUP_IDandDEPT_ID(cmd1);
cmd.Parameters.Clear();
string strSQL3 = " INSERT INTO MIP_HAPPY_TARGET (HAPPY_TARGET_ID, HAPPY_ID,PCAGROUP_ID, DEPT_ID, DTYPE)values(@HAPPY_TARGET_ID, @HAPPY_ID, @PCAGROUP_ID, @DEPT_ID, @DTYPE) ";
cmd.CommandText = strSQL3;
foreach (Dictionary <string, string> get in targetList)
{
cmd.Parameters.Clear();
HAPPY_TARGET_ID = MIPLibrary.MIPUtil.getFILE_INDEX_SEQ(cmd.Connection, cmd.Transaction);
cmd.Parameters.Add(new SqlParameter("@HAPPY_TARGET_ID", HAPPY_TARGET_ID)); //tagertID編號
cmd.Parameters.Add(new SqlParameter("@HAPPY_ID", HAPPY_ID)); //mipmsg 編號
cmd.Parameters.Add(new SqlParameter("@PCAGROUP_ID", get["PCAGROUP_ID"])); //群組id
cmd.Parameters.Add(new SqlParameter("@DEPT_ID", get["DEPT_ID"])); //單位id
cmd.Parameters.Add(new SqlParameter("@DTYPE", "1"));
nRet = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
if (nRet == -1)
{
cmd.Transaction.Rollback();
return(nRet);
}
}
}
return(nRet);
}
