public static string UpLoadActivity(byte[] data, string ATEKIND, string MATERIALHANDLE, string PROCESS, string sLogonUserId, string FileName = "")
{
try
{
FileName = (FileName == "") ? (ATEKIND + ".xml") : FileName;
string str = CommSecurity.GetMD5HashFromByte(data);
SqlConnection connection = new SqlConnection(CommSecurity.GetConnectionString());
connection.Open();
SqlCommand cmd = new SqlCommand("UPLOADATESTATUS", connection);
cmd.CommandType = CommandType.StoredProcedure;
CommSecurity.SetCommandParam(ref cmd, SqlDbType.VarChar, "ATEKIND", ATEKIND);
CommSecurity.SetCommandParam(ref cmd, SqlDbType.VarChar, "MATERIALHANDLE", MATERIALHANDLE);
CommSecurity.SetCommandParam(ref cmd, SqlDbType.VarChar, "PROCESS", PROCESS);
CommSecurity.SetCommandParam(ref cmd, SqlDbType.VarChar, "FILENAME", FileName);
CommSecurity.SetCommandParam(ref cmd, SqlDbType.VarChar, "FileTimeTag", str);
CommSecurity.SetCommandParam(ref cmd, SqlDbType.Image, "FILES", data);
CommSecurity.SetCommandParam(ref cmd, SqlDbType.VarChar, "UpdateUser", sLogonUserId);
//新加的
cmd.Parameters.Add("@TRES", SqlDbType.VarChar, 100);
cmd.Parameters["@TRES"].Direction = ParameterDirection.Output; //要设置长度
cmd.ExecuteNonQuery();
connection.Close();
string result = Convert.ToString(cmd.Parameters["@TRES"].Value);
return(result);
}
catch (Exception exception)
{
throw exception;
}
}
public static string ConnectDB(string sql, SqlParameter[] par = null)
{
string result = "";
using (SqlConnection con = new SqlConnection(CommSecurity.GetConnectionString()))
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
if (par != null)
{
cmd.Parameters.AddRange(par);
}
int i = cmd.ExecuteNonQuery();
con.Close();
return(result = "ok");
}
catch (Exception ex)
{
DataUtils.LOGINFO.WriteError(ex.Message + Environment.NewLine + ex.Source + Environment.NewLine + ex.StackTrace);
return(result = ex.Message + Environment.NewLine + ex.Source + Environment.NewLine + ex.StackTrace);
}
}
}
public static string UpdataUserLayoutByActivity(string ActivityFile, string ActivityName, string UserID, List <DockLayoutManager> dlmList)
{
string result = "OK";
if (StaticInfo.LocalModel == "LOCAL")
{
}
else
{
foreach (DockLayoutManager dlm in dlmList)
{
System.IO.MemoryStream ms = new System.IO.MemoryStream();
dlm.SaveLayoutToStream(ms);
ms.Position = 0;
int len1 = Convert.ToInt32(ms.Length);
byte[] data = new byte[len1];
ms.Read(data, 0, len1);
ms.Close();
//string SQLStr = CommSecurity.GetConnectionString();
string SQLStr = "";
SQLStr = CommSecurity.GetConnectionString();
SqlConnection conn = new SqlConnection(SQLStr);
conn.Open();
SqlCommand cmd = new SqlCommand("UPDATE_SYS_LAYOUT", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ACTIVITYFILE", SqlDbType.VarChar);
cmd.Parameters["@ACTIVITYFILE"].Value = ActivityFile;
cmd.Parameters.Add("@ACTIVITYNAME", SqlDbType.VarChar);
cmd.Parameters["@ACTIVITYNAME"].Value = ActivityName;
cmd.Parameters.Add("@LAYOUTID", SqlDbType.VarChar);
cmd.Parameters["@LAYOUTID"].Value = dlm.Name;
cmd.Parameters.Add("@FILESTREAM", SqlDbType.Image);
cmd.Parameters["@FILESTREAM"].Value = data;
cmd.Parameters.Add("@UPDATEUSER", SqlDbType.VarChar);
cmd.Parameters["@UPDATEUSER"].Value = UserID;
cmd.Parameters.Add("@TRES", SqlDbType.VarChar, 100);
cmd.Parameters["@TRES"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
conn.Close();
if (!Convert.ToString(cmd.Parameters["@TRES"].Value).StartsWith("OK"))
{
result = Convert.ToString(cmd.Parameters["@TRES"].Value);
break;
}
}
}
return(result);
}
/// <summary>
/// Save the State File
/// </summary>
/// <param name="ManualConnectionList"></param>
/// <returns></returns>
public static string SaveStateModel(byte[] bytes, string id)
{
string result = "";
//byte[] data = Encoding.Unicode.GetBytes(JasonStr);
string strMD5 = CommSecurity.GetMD5HashFromByte(bytes);
result = DB.ExecProc("UPDATE_SYS_TEST_PLAN",
new DBParameters(System.Data.SqlDbType.NChar, "@Action", "UPDATE"),
new DBParameters(System.Data.SqlDbType.NVarChar, "@FileID", id),
new DBParameters(System.Data.SqlDbType.NVarChar, "@SYS_USER_ID", DataUtils.StaticInfo.LoginUser),
new DBParameters(System.Data.SqlDbType.NVarChar, "@FileDisp", strMD5),
new DBParameters(System.Data.SqlDbType.Image, "@StateData", bytes)
);
return(result);
}
public static string UpdateFileDB(byte[] data, string FileID)
{
string FileDisp = CommSecurity.GetMD5HashFromByte(data);
SqlParameter[] par = { new SqlParameter("@TestFile", data) };
string JarContent = Convert.ToBase64String(data);
string sql = @"update ATE_Test_FILE
set SYS_USER_ID='{0}',
FileDisp='{1}',
StateData= @TestFile,
UpdateTime='{2}'
where FileID='{3}'";
string sqlStr = string.Format(sql, DataUtils.StaticInfo.LoginUser, FileDisp, DateTime.Now, FileID);
return(ConnectDB(sqlStr, par));
}
public static Boolean UploadActivity(string FullPath)
{
string FullName = FullPath;
string ActivityName = "";
string ActivityPath = "";
string SupportLocal = "";
string FileName = System.IO.Path.GetFileNameWithoutExtension(FullName);
if (".DLL".Equals(System.IO.Path.GetExtension(FullName).ToUpper()))
{
try
{
string fileName = System.IO.Path.GetFileNameWithoutExtension(FullName);
if (fileName.ToUpper().StartsWith("DEVEXPRESS."))
{
ActivityPath = "DevLibs";
ActivityName = System.IO.Path.GetFileName(FullName);
SupportLocal = "Y";
}
else if (fileName.ToUpper().StartsWith("SYSTEM."))
{
ActivityPath = "System";
ActivityName = System.IO.Path.GetFileName(FullName);
SupportLocal = "Y";
}
else
{
ActivityPath = "";
ActivityName = System.IO.Path.GetFileName(FullName);
SupportLocal = "Y";
}
}
catch (Exception)
{
ActivityPath = "";
ActivityName = System.IO.Path.GetFileName(FullName);
SupportLocal = "Y";
}
}
else if (".ZIP".Equals(System.IO.Path.GetExtension(FullName).ToUpper()))
{
}
else
{
ActivityPath = System.IO.Path.GetExtension(FullName).ToUpper().Substring(1);
ActivityName = System.IO.Path.GetFileName(FullName);
if ("XML.".Equals(ActivityPath) && FileName.ToUpper().StartsWith("SYSTEM."))
{
ActivityPath = "SYSTEM";
}
else if ("XML".Equals(ActivityPath) && FileName.ToUpper().StartsWith("DEVEXPRESS."))
{
ActivityPath = "DevLibs";
}
else if ("XML".Equals(ActivityPath))
{
ActivityPath = "";
}
else if ("JPG".Equals(ActivityPath))
{
ActivityPath = "IMAGE";
}
else if ("JPEG".Equals(ActivityPath))
{
ActivityPath = "IMAGE";
}
else if ("PNG".Equals(ActivityPath))
{
ActivityPath = "IMAGE";
}
else if ("BMP".Equals(ActivityPath))
{
ActivityPath = "IMAGE";
}
else if ("EXE".Equals(ActivityPath))
{
ActivityPath = "";
}
else if ("CONFIG".Equals(ActivityPath))
{
ActivityPath = "";
}
else if ("XAML".Equals(ActivityPath))
{
ActivityPath = "RESOURCE";
}
}
System.IO.FileStream fs = new System.IO.FileStream(FullName, FileMode.Open, FileAccess.Read);
string fileMD5str = GetMD5HashFromFile(fs);
int len1 = Convert.ToInt32(fs.Length);
byte[] data = new byte[len1];
fs.Read(data, 0, len1);
fs.Close();
string SQLStr = CommSecurity.GetConnectionString();
SqlConnection conn = new SqlConnection(SQLStr);
conn.Open();
SqlCommand cmd = new SqlCommand("UPLOADACTIVITYFILE_DS_PA", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FILENAME", SqlDbType.VarChar);
cmd.Parameters["@FILENAME"].Value = ActivityName;
cmd.Parameters.Add("@QCode", SqlDbType.VarChar);
cmd.Parameters["@QCode"].Value = "";
cmd.Parameters.Add("@ACTIVITYNAME", SqlDbType.VarChar);
cmd.Parameters["@ACTIVITYNAME"].Value = FileName;
cmd.Parameters.Add("@ACTIVITYGROUP", SqlDbType.VarChar);
cmd.Parameters["@ACTIVITYGROUP"].Value = ActivityPath;
cmd.Parameters.Add("@ACTIVITYNAMEDESC", SqlDbType.VarChar);
cmd.Parameters["@ACTIVITYNAMEDESC"].Value = "";
cmd.Parameters.Add("@ACTIVITYGROUPDESC", SqlDbType.VarChar);
cmd.Parameters["@ACTIVITYGROUPDESC"].Value = "";
cmd.Parameters.Add("@PATH", SqlDbType.VarChar);
cmd.Parameters["@PATH"].Value = ActivityPath;
cmd.Parameters.Add("@IsActivity", SqlDbType.VarChar);
cmd.Parameters["@IsActivity"].Value = SupportLocal;
cmd.Parameters.Add("@FILE", SqlDbType.Image);
cmd.Parameters["@FILE"].Value = data;
cmd.Parameters.Add("@FileTimeTag", SqlDbType.VarChar);
cmd.Parameters["@FileTimeTag"].Value = fileMD5str;
cmd.Parameters.Add("@TRES", SqlDbType.VarChar, 100);
cmd.Parameters["@TRES"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
conn.Close();
return(Convert.ToString(cmd.Parameters["@TRES"].Value).ToUpper().StartsWith("OK"));
}
